Postgres Pro
Downloads
Home   >   mailing lists

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 20070219212801.GA3292@wolff.to
Whole thread Raw
In response to Re: 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
Tree view 
On Mon, Feb 19, 2007 at 20:48:07 +0100,
  Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
>
> What time of day were you born ?
>
>     http://en.wikipedia.org/wiki/Apgar
>
> What is the technical reason that makes you wonder ?

Because it would make doing the queries simpler.
If you aren't collecting the data, it doesn't make sense to deal with the
extra headaches involved with pretending you know what time of day someone
was born.

pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: RPM compat-postgresql-libs-4-2 for IA-64
Next
From: "Merlin Moncure"
Date:
Subject: boolean operator on interval producing strange results