Re: SETOF - Mailing list pgsql-sql

From Christoph Haller
Subject Re: SETOF
Date
Msg-id 3E65F78E.7455651B@rodos.fzk.de
Whole thread Raw
In response to SETOF  (Fernando <fernando@icreativa.com.mx>)
Responses Re: SETOF  (Greg Stark <gsstark@mit.edu>)
Re: SETOF  (Greg Stark <gsstark@mit.edu>)
List pgsql-sql
>
>
> Christoph Haller <ch@rodos.fzk.de> writes:
>
> > You cannot obtain several columns from SQL functions.
> > See the list archives (search for SETOF) for details.
> > You have to use e.g. a plpgsql function instead.
>
> How do you do it with a plpgsql function?
>
>
Sorry, Fernando, I was wrong. It works from version 7.3.
The reason why it's not working on your machine is probably
because of a prior version.

And Greg, refer to
http://techdocs.postgresql.org/guides/SetReturningFunctions

I think it will fit your needs.

Regards, Christoph




pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: SETOF
Next
From: Christoph Haller
Date:
Subject: Re: LIMIT and SUBQUERIES