Re: Empty date - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Empty date
Date
Msg-id 20050403132604.GH27923@wolff.to
Whole thread Raw
In response to Re: Empty date  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: Empty date  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
On Sun, Apr 03, 2005 at 11:06:22 +0200,
  Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
> On Thu, Mar 31, 2005 at 09:43:27AM +0300, Andrus wrote:
>
> > Empty data is a date which is less that all other dates.
>
> Why would that be ? "<Empty> of type <unknown>" cannot be less
> than (nor more than nor equal to) "<not empty> of type <date>".
> If you want to express the valid idea of "<less-than-anything>
> of type <date>" you are better off using a logical construct
> tailored for that purpose. It may help to use "<4734-01-01 BC> of
> type <date>" or some such. However the best would be to use
> "-infinity". See the docs.

+/- infinity are only available as timestamps, not dates.

pgsql-general by date:

Previous
From: Mage
Date:
Subject: what's the best in 8.0
Next
From: Karsten Hilbert
Date:
Subject: Re: Empty date