Обсуждение: PL/Pgsql and Nulls

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

PL/Pgsql and Nulls

От
wsmuir@islandnet.com
Дата:
Hey all,

I'm just working on some PL/Pgsql funtions and have noticed someting a
little unexpected...

Postgresql 7.0.2
I'm attempting to write a PL function which will take 3 parameters,
all text type, and the 3rd can be null...

after a little testing, what is happening is if the 3rd parameter is
explicitly a null    ie      select pl_func('002','001',null);
it makes $1 and $2 inside the fuction null as well...

is this a 'don't do that' situation or is this a bug?

Thanks,
scott.