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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
