Re: Two fixes for plpgsql.sgml
От | Guillaume Lelarge |
---|---|
Тема | Re: Two fixes for plpgsql.sgml |
Дата | |
Msg-id | 474DEEC8.80502@lelarge.info обсуждение исходный текст |
Ответ на | Re: Two fixes for plpgsql.sgml (Bruce Momjian <bruce@momjian.us>) |
Список | 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
В списке pgsql-docs по дате отправления: