Re: Return Value of a Function - Mailing list pgsql-general

From Tom Lane
Subject Re: Return Value of a Function
Date
Msg-id 11059.1075741089@sss.pgh.pa.us
Whole thread Raw
In response to Re: Return Value of a Function  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> You could return a SETOF myrowtype where the set contains only one row -
> that's probably what you're after. Then you can do things like:

> SELECT * FROM set_returning_function(1,'a');

You're confusing SETOF with returning a composite type --- actually they
are orthogonal features that can be used separately.  Obviously the docs
could stand to be improved in this area :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Return Value of a Function
Next
From: Terry Lee Tucker
Date:
Subject: Re: Return Value of a Function