Re: infinity as a date - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: infinity as a date
Date
Msg-id 20021211131345.GA8475@wolff.to
Whole thread Raw
In response to infinity as a date  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
On Wed, Dec 11, 2002 at 16:11:12 +0900,
  Jean-Christian Imbeault <jc@mega-bucks.co.jp> wrote:
> I see that Postgres has a special keyword "infinity" for use with
> timestamps. Is there an equivalent for dates?

Dates cannot have a value of 'infinity'. Either you can store timestamps
instead of dates or use another column to indicate to indicate the date
is infinite and have your tests check that column as well as the date
column.

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Urgent need of (paid) PostgreSQL support in New
Next
From: Jean-Christian Imbeault
Date:
Subject: Re: infinity as a date