Re: A question about PL/pgSQL DECLAREd variable behavior - Mailing list pgsql-general

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