On Sun, Sep 26, 2010 at 10:15:00AM -0400, Tom Lane wrote: > David Fetter <david@xxxxxxxxxx> writes: > > On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote: > >> 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? > > I looked at that yesterday. It would take significant restructuring > of the code involved :-( ... the place that throws the error doesn't > know exactly what subnode was found to be mutable, and IIRC it > hasn't got access to the original command string anyway. How much restructuring are we talking about here? 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