Re: Why *exactly* is date_trunc() not immutable ? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Why *exactly* is date_trunc() not immutable ?
Date
Msg-id 20070219184111.GA24810@wolff.to
Whole thread Raw
In response to Why *exactly* is date_trunc() not immutable ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: Why *exactly* is date_trunc() not immutable ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List 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 by date:

Previous
From: John Cole
Date:
Subject: Out of memory on vacuum analyze
Next
From: Jeff Davis
Date:
Subject: Re: Out of memory on vacuum analyze