<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.118 2007/11/2815:42:31 petere Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/plpgsql.sgml,v 1.119 2007/11/2820:13:06 momjian Exp $ -->

<chapter id="plpgsql">

<title><application>PL/pgSQL</application> - <acronym>SQL</acronym> Procedural Language</title>

<para>

<application>PL/pgSQL</> functions can also be declared to return

a <quote>set</>, or table, of any data type they can return a single

instance of. Such a function generates its output by executing

<command>RETURN NEXT</> for each desired element of the result

a <quote>set</>, or table. 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.

</para>

WHERE fooid &gt; 0

LOOP

-- can do some processing here

RETURN NEXT r; -- returnnext row of SELECT

RETURN NEXT r; -- returncurrent row of SELECT

END LOOP;

RETURN;

END