Re: date_trunc'd timestamp index possible?

Bruno Wolff III <bruno@wolff.to>

From: Bruno Wolff III <bruno@wolff.to>
To: "D. Duccini" <duccini@backpack.com>, pgsql-sql@postgresql.org, Pgsql-novice <pgsql-novice@postgresql.org>
Date: 2004-10-01T18:44:37Z
Lists: pgsql-hackers, pgsql-novice, pgsql-sql
On Fri, Oct 01, 2004 at 13:28:30 -0500,
  Bruno Wolff III <bruno@wolff.to> wrote:
> 
> I am not sure how to check if the supplied function for converting
> a timestamp with time zone to a timestamp without timezone using a
> specified time zone is immutable. I think this function should be
> immutable, but that it probably isn't.

I found that most of the various timezone functions are marked as stable
instead of immutable. I think at least a couple of these should be
marked as immutable and I will try reporting this as a bug.