Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Two fixes for plpgsql.sgml



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group