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

From Tom Lane
Subject Re: returning more than one value from a function
Date
Msg-id 10764.1272754567@sss.pgh.pa.us
Whole thread Raw
In response to Re: returning more than one value from a function  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: returning more than one value from a function  (Lonni J Friedman <netllama@gmail.com>)
List pgsql-novice
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.

            regards, tom lane

pgsql-novice by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: returning more than one value from a function
Next
From: gargoyle60
Date:
Subject: Re: PostgreSQL Book