Re: date_trunc'd timestamp index possible? - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: date_trunc'd timestamp index possible?
Date
Msg-id 20041001184437.GA21599@wolff.to
Whole thread Raw
In response to Re: date_trunc'd timestamp index possible?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
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.

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: date_trunc'd timestamp index possible?
Next
From: Tom Lane
Date:
Subject: Re: [SQL] date_trunc'd timestamp index possible?