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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
