On 10/22/15 8:52 PM, Dane Foster wrote:
It just occurred to me that another option, for my specific example, would be to record/cache FOUND instead of testing the RECORD variable for its NULLness. Unless of course assigning FOUND to a variable is a pass-by-reference assignment, which in the actual code that I'm writing would be problematic because FOUND is set many times because there are at least 4 SQL commands that my function executes.
AFAIK, functions don't really do pass by reference, except for INOUT parameters. In any case, FOUND is definitely reset when you do things like SELECT INTO.
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
