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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why *exactly* is date_trunc() not immutable ?
Date: 2007-02-18 17:54:26
Message-ID: 8061.1171821266@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
>> So I figured it would make sense to add a functional index
>> on date_trunc('day', dob) to the patients table. Which
>> worked (appeared to, at least) with PG 7.4.

For the record, this was changed just before 8.0 release:
http://archives.postgresql.org/pgsql-hackers/2004-10/msg00030.php

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guido Neitzer 2007-02-18 18:07:57 Re: Database performance comparison paper.
Previous Message Joshua D. Drake 2007-02-18 16:57:42 Re: open source - content management system - that uses PostGreSQL