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  (Bruno Wolff III <bruno@wolff.to>)
Список 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 по дате отправления:

Предыдущее
От: "Sim Zacks"
Дата:
Сообщение: Re: [Fwd: [webmaster] in Search of free hosting with PostgreSQL]
Следующее
От: Poul Møller Hansen
Дата:
Сообщение: How many clients can one database server handle