Re: Empty date
| От | Karsten Hilbert |
|---|---|
| Тема | Re: Empty date |
| Дата | |
| Msg-id | 20050403110622.A568@hermes.hilbert.loc обсуждение |
| Ответ на | Re: Empty date ("Andrus" <noeetasoftspam@online.ee>) |
| Ответы |
Re: Empty date
|
| Список | pgsql-general |
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. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
В списке pgsql-general по дате отправления: