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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
