Re: returning more than one value from a function - Mailing list pgsql-novice

From Lonni J Friedman
Subject Re: returning more than one value from a function
Date
Msg-id w2y7c1574a91005041547vfdddd8c0y8a60988d55fdc76d@mail.gmail.com
Whole thread Raw
In response to Re: returning more than one value from a function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
On Sat, May 1, 2010 at 3:56 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Lonni J Friedman <netllama@gmail.com> writes:
>> ...  Now I've got the
>> opposite problem, namely that I can't find a way to have my function
>> not return anything at all.  Whenever I try to remove the 'RETURN AS
>> ....' portion of the function, it fails to get created.  Is it not
>> possible to have a function that returns nothing?
>
> Declare it as RETURNS VOID.  This is really just window dressing, as
> the actual behavior is to return a null value, but it documents your
> intention.

thanks, that is exactly what I needed.

pgsql-novice by date:

Previous
From: Shoaib Mir
Date:
Subject: Re: Database Replay
Next
From: Tony Day
Date:
Subject: Autovaccum and Full vacuum