Re: How to specify infinity for intervals ?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to specify infinity for intervals ?
Date: 2006-02-22 03:12:45
Message-ID: 20060222031245.GA11757@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 20, 2006 at 19:24:05 +0100,
Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> wrote:
>
> I *could*, of course, use something like '999 years' as a
> special value to indicate "no upper limit" figuring that no
> one is going to live that long in the foreseeable future.

I would think that specifying a value well beyond the current life
expectency for people would be the simplest solution. Since it doesn't
have to be treated like a magic value and can used consistantly with
other values in the same column.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nareen S 2006-02-22 06:10:53 Postgresql Replication
Previous Message Michael Glaesemann 2006-02-21 22:59:06 Re: How to specify infinity for intervals ?