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
Дата:
FAQ