<!--

$Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.56 2002/04/0902:43:25 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.57 2002/04/0903:08:25 momjian Exp $

-->

<chapter id="plpgsql">

to worry about that, since FOR loops automatically use a cursor

internally to avoid memory problems.) A more interesting usage is to

return a reference to a cursor that it has created, allowing the

caller to read the rows. This providesone wayof returning multiple

rows and columnsfroma function.

caller to read the rows. This providesa wayto return row sets

fromfunctions.

</para>

<sect2 id="plpgsql-cursor-declarations">

reffunc2

--------------------

&gt;unnamed cursor 1&lt;

&lt;unnamed cursor 1&gt;

(1 row)

FETCH ALL IN "&gt;unnamed cursor 1&lt;";

FETCH ALL IN "&lt;unnamed cursor 1&gt;";

COMMIT;

</programlisting>

</para>