Re: Empty date
От | Bruno Wolff III |
---|---|
Тема | Re: Empty date |
Дата | |
Msg-id | 20050403132604.GH27923@wolff.to обсуждение исходный текст |
Ответ на | Re: Empty date (Karsten Hilbert <Karsten.Hilbert@gmx.net>) |
Ответы |
Re: Empty date
|
Список | 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 по дате отправления: