Can not use NULL values at all

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Can not use NULL values at all
Date: 2000-10-27 18:14:15
Message-ID: 200010271814.e9RIEFc53013@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PL/pgSQL functions: NULL parameter trouble (vpryadkin(at)sectorbase(dot)com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Can not use NULL values at all

Long Description
If one of parameters is NULL, all another parameters
take NULL values regardless of transmitted NOT NULL values.

Sample Code
create function x (text,text,text) returns text as '
begin
return $1;
end;
' language 'plpgsql';

x ('aa', 'bb', ''); -- returns 'aa', Ok
x ('aa', null, 'qq'); -- returns NULL !!!

No file was uploaded with this report

Browse pgsql-bugs by date

  From Date Subject
Next Message Darcy Buskermolen 2000-10-27 18:55:24 Re: Updating multiple bool values crashes backend
Previous Message Pryadkin, Vyacheslav 2000-10-27 17:41:27 PL/pgSQL functions: NULL parameter trouble