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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why *exactly* is date_trunc() not immutable ?
Date: 2007-02-19 21:28:01
Message-ID: 20070219212801.GA3292@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 19, 2007 at 20:48:07 +0100,
Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-02-19 21:39:53 boolean operator on interval producing strange results
Previous Message Devrim GUNDUZ 2007-02-19 21:24:08 Re: RPM compat-postgresql-libs-4-2 for IA-64