Re: function returning NULL? - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: function returning NULL?
Date
Msg-id 14767.988640664@sss.pgh.pa.us
Whole thread Raw
In response to function returning NULL?  (Sandro Dentella <sandro.dentella@tin.it>)
List pgsql-interfaces
Sandro Dentella <sandro.dentella@tin.it> writes:
> I'm trying to create a function that should return a date, and occasionally
> NULL value. I can't see how to do that. I'm using pl/tcl.

You need the "return_null" command, which is new in 7.1 --- before that
there was no way to do it in pltcl.

"return_null" seems to be missing from the documentation :-(.  No wonder
you couldn't find it.

            regards, tom lane

pgsql-interfaces by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: libpgtcl and passwords
Next
From: Constantin Teodorescu
Date:
Subject: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it