Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Why *exactly* is date_trunc() not immutable ?
Date
Msg-id 8061.1171821266@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why *exactly* is date_trunc() not immutable ?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
Karsten Hilbert <Karsten.Hilbert@gmx.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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: open source - content management system - that uses PostGreSQL
Next
From: Guido Neitzer
Date:
Subject: Re: Database performance comparison paper.