Re: infinity as a date

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: infinity as a date
Date: 2002-12-11 13:13:45
Message-ID: 20021211131345.GA8475@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 11, 2002 at 16:11:12 +0900,
Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2002-12-11 13:14:12 Re: infinity as a date
Previous Message Shridhar Daithankar 2002-12-11 11:19:55 Re: Urgent need of (paid) PostgreSQL support in New