[SQL] Re: [GENERAL] All function parameters become NULL if one is?

[Peter Eisentraut]

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      [EMAIL PROTECTED]       http://yi.org/peter-e/