Re: pl/pgsql function problem

On Sat, 2001-09-08 at 01:09, David Mulcahy wrote:
> I am having problems doing what seems to be a very simple thing. All I
> need is to join 2 or more variables (eg char, int, date) and return them
> as a single varchar variable.
>
> eg ret := int + char + date; or better still join("+", int,char,date)
> return ret;

Use COALESCE( VALUE, ...) to replace nulls with default values - it will
return the first non-null argument from the list of values.

Older versions of PL/PGSQL will always return null if any argument to
the function is null, so you may have to use this where you _call_ the
function, rather than within the function.

Regards,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew @ catalyst . net . nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64(21)635-694, Fax:+64(4)499-5596, Office: +64(4)499-2267xtn709