Re: SETOF

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Cc: fernando(at)icreativa(dot)com(dot)mx, gsstark(at)mit(dot)edu
Subject: Re: SETOF
Date: 2003-03-05 13:11:42
Message-ID: 3E65F78E.7455651B@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>
>
> Christoph Haller <ch(at)rodos(dot)fzk(dot)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

Responses

  • Re: SETOF at 2003-03-05 13:36:29 from Greg Stark
  • Re: SETOF at 2003-03-05 13:37:11 from Greg Stark

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-03-05 13:24:27 Re: LIMIT and SUBQUERIES
Previous Message Greg Stark 2003-03-05 12:47:50 Re: SETOF