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 по дате отправления:

Предыдущее
От: Mage
Дата:
Сообщение: what's the best in 8.0
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: Empty date