Re: All function parameters become NULL if one is? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: All function parameters become NULL if one is?
Date
Msg-id Pine.LNX.4.21.0009171644160.576-100000@peter
Whole thread Raw
In response to All function parameters become NULL if one is?  ("Joel Burton" <jburton@scw.org>)
List pgsql-general
Joel Burton writes:

> I have a function that takes two text parameters. If both of these
> are non-null, everything works fine. However, if one of these two
> parameters is null and one is not, the function receives both as null.

Worse, no matter what the function does, the return value is also null.

> Is this intentional? Is there a way around this?

Wait for 7.1.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: How do I add a column to an existing table.
Next
From: John Draper
Date:
Subject: Re: How do I add a column to an existing table.