Re: How to specify infinity for intervals ? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: How to specify infinity for intervals ?
Date
Msg-id 20060222031245.GA11757@wolff.to
Whole thread Raw
In response to How to specify infinity for intervals ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
On Mon, Feb 20, 2006 at 19:24:05 +0100,
  Karsten Hilbert <Karsten.Hilbert@gmx.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.

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: How to specify infinity for intervals ?
Next
From: "Nareen S"
Date:
Subject: Postgresql Replication