On Thu, Oct 22, 2015 at 2:00 PM, Jim Nasby <jim.na...@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
