The reason is that you've declared the function STABLE
Yes, that did it!
I'm not sure if the cited portions of the manual ought to contain notes about this or not. It seems a bit off-topic for them, but if other people have been bit by this, then maybe ... comments anyone?
Perhaps this should be documented on the page describing CREATE FUNCTION (which is what I referenced when I wrote the function)?
In particular, the wording describing IMMUTABLE, STABLE VOLATILE doesn't seem entirely accurate:
"STABLE ... is the appropriate selection for functions whose results depend on database lookups, parameter variables (such as the current time zone), etc."
Apparently not the case for after-update triggers that need to reference the just-updated table.
Regardless, thank you very much for the help! Karl Nack Futurity, Inc. 773-506-2007 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
