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)
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 |