Re: plperl function to return nulls - Mailing list pgsql-general

From Michael Fuhr
Subject Re: plperl function to return nulls
Date
Msg-id 20050919132749.GB83744@winnie.fuhr.org
Whole thread Raw
In response to plperl function to return nulls  (Brent Wood <b.wood@niwa.co.nz>)
List pgsql-general
On Mon, Sep 19, 2005 at 10:52:23AM +1200, Brent Wood wrote:
> I have a plperl function returning an int. The int is returned as the
> result of a system call.
>
> It is set to return a null if one of the inputs is null, but I can't see
> how to return a null if the result is indeterminate. The function
> currently returns a 0 instead.
>
> How do I stick an if in the function to return a null where appropriate?

From the PL/Perl documentation:

"As shown above, to return an SQL null value from a PL/Perl function,
return an undefined value."

http://www.postgresql.org/docs/8.0/interactive/plperl.html

Is that what you're looking for?

--
Michael Fuhr

pgsql-general by date:

Previous
From: Mario Weilguni
Date:
Subject: Re: How to modify a tuple returned by SPI_copytuple?
Next
From: "Pierre Racine"
Date:
Subject: HELP - Recover function delete