PL/Pgsql and Nulls - Mailing list pgsql-novice

From wsmuir@islandnet.com
Subject PL/Pgsql and Nulls
Date
Msg-id 010301220705@islandnet.com
Whole thread Raw
List pgsql-novice
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.

pgsql-novice by date:

Previous
From: Larry Holish
Date:
Subject: message from backend
Next
From: Eugene Lee
Date:
Subject: Re: outer join not supported?