Thread: PL/pgSQL functions: NULL parameter trouble

PL/pgSQL functions: NULL parameter trouble

From
"Pryadkin, Vyacheslav"
Date:
PL/pgSQL functions:
if one of parameters is NULL, all another parameters
take NULL values regardless of transmitted NOT NULL values.
----------------------
Vyacheslav Pryadkin
Software Engineer
SECTORBASE.com
568 Howard Str, First Floor
SF, CA, 94105
(415)365-8234
(415)760-0267 (cell)

Re: PL/pgSQL functions: NULL parameter trouble

From
Thomas Lockhart
Date:
> PL/pgSQL functions:
> if one of parameters is NULL, all another parameters
> take NULL values regardless of transmitted NOT NULL values.

This was true in previous releases, but v7.1 will have this behavior
changed to allow passing a mix of NULL and non-NULL values to
subroutines.

                    - Thomas