PL/pgSQL functions: NULL parameter trouble ([EMAIL PROTECTED]) 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
