Re: Two fixes for plpgsql.sgml

Guillaume Lelarge <guillaume@lelarge.info>

From: Guillaume Lelarge <guillaume@lelarge.info>
To: Bruce Momjian <bruce@momjian.us>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, Tom Lane <tgl@sss.pgh.pa.us>, Neil Conway <neilc@samurai.com>, pgsql-docs@postgresql.org
Date: 2007-11-28T22:42:16Z
Lists: pgsql-docs
Bruce Momjian a écrit :
> Alvaro Herrera wrote:
>>[...]
>> The point of "any datatype they can return a single instance of" is that
>> this can be a set of scalar values (e.g. "RETURNS SETOF int") or of a
>> complex type ("RETURNS SETOF table"), or anything else they can return a
>> single instance of :-P (SETOF anyelement?  SETOF table%TYPE?)
> 
> Good idea, updated:
> 
>      <application>PL/pgSQL</> functions can also be declared to return
>      a <quote>set</> (or table) of any data type that can be returned as
>      a single instance.  Such a function generates its output by executing
>      <command>RETURN NEXT</> for each desired element of the result
>      set, or by using <command>RETURN QUERY</> to output the result of
>      evaluating a query.
> 

Great. Now I better understand this part. Thank you all.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com