On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote: > Eric McKeeth <eldi...@gmail.com> 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 <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
