On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote: > Eric McKeeth <eldin00@xxxxxxxxx> writes: > > why would I get the following error, since the period() function > > is in fact declared as immutable? > > > test=# ALTER TABLE test3 ADD exclude using > > gist(period(effect_date::timestamptz, expire_date::timestamptz) > > with && ); ERROR: functions in index expression must be marked > > IMMUTABLE > > period() might be immutable, but those casts from date to > timestamptz are not, because they depend on the TimeZone parameter. How hard would it be to point out the first expression found to be mutable? All of them? Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
