Thread: Returning rows from functions

Returning rows from functions

From
"David Durst"
Date:
I was wondering if there was a way of returning a complete row from a
function, in reading the documentation of CREATE FUNCTION. I was under the
impression that you could return a row by using setof, but this does not
seem to be true.
Can anyone help?




Re: Returning rows from functions

From
Joe Conway
Date:
David Durst wrote:
> I was wondering if there was a way of returning a complete row from a
> function, in reading the documentation of CREATE FUNCTION. I was under the
> impression that you could return a row by using setof, but this does not
> seem to be true.
> Can anyone help?

The short answer is "yes, but..."; see the thread at:
http://archives.postgresql.org/pgsql-interfaces/2002-06/msg00042.php
for a recent discussion about this.

HTH,

Joe