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

From Dane Foster
Subject Re: A question about PL/pgSQL DECLAREd variable behavior
Date
Msg-id CA+WxinJNbR6Pg_yJuJLvntJRkv9r8XYrDKhxEg2OwuuP_TdDSg@mail.gmail.com
Whole thread Raw
In response to Re: A question about PL/pgSQL DECLAREd variable behavior  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: A question about PL/pgSQL DECLAREd variable behavior  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-general
On Thu, Oct 22, 2015 at 2:00 PM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
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

​​Please elaborate. I'm entirely new to PL/pgSQL so the more details you can provide the better.​
Thanks,

Dane

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: temporary indexes?
Next
From: Jonathan Vanasco
Date:
Subject: Re: temporary indexes?