Re: A question about PL/pgSQL DECLAREd variable behavior

Поиск
Список
Период
Сортировка
От Dane Foster
Тема Re: A question about PL/pgSQL DECLAREd variable behavior
Дата
Msg-id CA+WxinJNbR6Pg_yJuJLvntJRkv9r8XYrDKhxEg2OwuuP_TdDSg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: A question about PL/pgSQL DECLAREd variable behavior  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: A question about PL/pgSQL DECLAREd variable behavior
Список 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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: temporary indexes?
Следующее
От: Jonathan Vanasco
Дата:
Сообщение: Re: temporary indexes?