Обсуждение: PL/pgSQL functions: NULL parameter trouble

Поиск
Список
Период
Сортировка

PL/pgSQL functions: NULL parameter trouble

От
"Pryadkin, Vyacheslav"
Дата:
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

От
Thomas Lockhart
Дата:
> 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