BUG #15166: PL/PGSQL default rowtype variable value is null but also not null

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: cdalxndr(at)yahoo(dot)com
Subject: BUG #15166: PL/PGSQL default rowtype variable value is null but also not null
Date: 2018-04-20 21:57:01
Message-ID: 152426142167.459.1224353227133000998@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15166
Logged by: Alex
Email address: cdalxndr(at)yahoo(dot)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)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2018-04-21 04:45:40 Re: BUG #15166: PL/PGSQL default rowtype variable value is null but also not null
Previous Message Justin Pryzby 2018-04-20 18:36:10 Re: BUG #14863: wrong reltuples statistics after vacuum without analyze