Re: Why *exactly* is date_trunc() not immutable ?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Why *exactly* is date_trunc() not immutable ?
Дата
Msg-id 20070219184111.GA24810@wolff.to
обсуждение исходный текст
Ответ на Why *exactly* is date_trunc() not immutable ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: Why *exactly* is date_trunc() not immutable ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
On Sun, Feb 18, 2007 at 12:29:17 +0100,
  Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
>
> The date-of-birth field in our table holding patients is of
> type "timestamp with time zone". One of our patient search
> queries uses the date-of-birth field to find matches. Since
> users enter day, month, and year but not hour, minute, and
> second of the DOB we run the query with

That seems like an odd choice. Is there some reason they didn't use a type
of date? Maybe you could get them to change it?

В списке pgsql-general по дате отправления:

Предыдущее
От: John Cole
Дата:
Сообщение: Out of memory on vacuum analyze
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Out of memory on vacuum analyze