On 10/21/15 9:32 PM, Dane Foster wrote:
"If STRICT is not specified in the INTO clause, then target will be set to the first row returned by the query, or to nulls if the query returned no rows." Foot removed from mouth.
Note however that there's some unexpected things when checking whether a record variable IS (NOT) NULL. It's not as simple as 'has the variable been set or not'.
-- 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general