PL/Pgsql and Nulls

From: wsmuir(at)islandnet(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: PL/Pgsql and Nulls
Date: 2001-03-02 06:07:05
Message-ID: 010301220705@islandnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-novice by date

  From Date Subject
Next Message Eugene Lee 2001-03-02 07:00:28 Re: outer join not supported?
Previous Message Larry Holish 2001-03-02 04:57:06 message from backend