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:
Please elaborate. I'm entirely new to PL/pgSQL so the more details you can provide the better.
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 по дате отправления: