Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-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

pgsql-docs by date

Next:From: Bruce MomjianDate: 2001-04-30 16:03:10
Subject: Re: Developer vs. Programmer
Previous:From: Vince VielhaberDate: 2001-04-30 14:24:08
Subject: Re: Developer vs. Programmer

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group