Hi,
This patch fixes two issues on plpgsql.sgml. Please review them
carefully, at least the second one. Thanks.
Regards.
PS : this patch should be in context diff if my .cvsrc is correctly set
up... at least, it doesn't look like my previous patch :)
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
Index: doc/src/sgml/plpgsql.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plpgsql.sgml,v
retrieving revision 1.117
diff -c -r1.117 plpgsql.sgml
*** doc/src/sgml/plpgsql.sgml 26 Oct 2007 01:11:09 -0000 1.117
--- doc/src/sgml/plpgsql.sgml 28 Nov 2007 07:11:58 -0000
***************
*** 133,139 ****
<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
set, or by using <command>RETURN QUERY</> to output the result of
--- 133,139 ----
<para>
<application>PL/pgSQL</> functions can also be declared to return
! a <quote>set</>, or table, or 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
set, or by using <command>RETURN QUERY</> to output the result of
***************
*** 1428,1434 ****
WHERE fooid > 0
LOOP
-- can do some processing here
! RETURN NEXT r; -- return next row of SELECT
END LOOP;
RETURN;
END
--- 1428,1434 ----
WHERE fooid > 0
LOOP
-- can do some processing here
! RETURN NEXT r; -- return current row of SELECT
END LOOP;
RETURN;
END