Re: [INTERFACES] function returning NULL?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sandro Dentella <sandro(dot)dentella(at)tin(dot)it>
Cc: pgsql-interfaces(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: [INTERFACES] function returning NULL?
Date: 2001-04-30 14:24:24
Message-ID: 14767.988640664@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-interfaces

Sandro Dentella <sandro(dot)dentella(at)tin(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2001-04-30 16:03:10 Re: Developer vs. Programmer
Previous Message Vince Vielhaber 2001-04-30 14:24:08 Re: Developer vs. Programmer

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2001-04-30 15:58:08 Re: libpgtcl and passwords
Previous Message Constantin Teodorescu 2001-04-30 14:05:34 Re: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it