BUG #15166: PL/PGSQL default rowtype variable value is null but alsonot null
От
PG Bug reporting form
Тема
BUG #15166: PL/PGSQL default rowtype variable value is null but alsonot null
Дата
Msg-id
152426142167.459.1224353227133000998@wrigleys.postgresql.org
Список
Дерево обсуждения
BUG #15166: PL/PGSQL default rowtype variable value is null but alsonot null PG Bug reporting form <noreply@postgresql.org>
Re: BUG #15166: PL/PGSQL default rowtype variable value is null but also not null Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: BUG #15166: PL/PGSQL default rowtype variable value is null butalso not null Alex <cdalxndr@yahoo.com>
Re: BUG #15166: PL/PGSQL default rowtype variable value is null but also not null Tom Lane <tgl@sss.pgh.pa.us>
The following bug has been logged on the website: Bug reference: 15166 Logged by: Alex Email address: cdalxndr@yahoo.com PostgreSQL version: 10.3 Operating system: Windows 10 version 1709 Description: Running the following script will report that 'var' is null but also not null: create table test_table(); create function test() returns void as $$ declare var test_table%rowtype; begin raise notice 'is null: %', (var is null); raise notice 'is not null: %', (var is not null); end; $$ LANGUAGE plpgsql; select test() produces output: NOTICE: is null: t NOTICE: is not null: t By documentation, it should be null: "If the DEFAULT clause is not given then the variable is initialized to the SQL null value." (https://www.postgresql.org/docs/current/static/plpgsql-declarations.html)
В списке pgsql-bugs по дате отправления
От: Justin Pryzby
Дата:
От: Andrew Gierth
Дата: