Message-ID: <474D160D.5090908@lelarge.info>
Date: Wed, 28 Nov 2007 08:17:33 +0100
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Thunderbird 2.0.0.6 (X11/20071022)
MIME-Version: 1.0
To: pgsql-docs@postgresql.org
Subject: Two fixes for plpgsql.sgml
Content-Type: multipart/mixed; boundary="------------040308060104090704010706"

This is a multi-part message in MIME format.
--------------040308060104090704010706
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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

--------------040308060104090704010706
Content-Type: text/x-patch;
 name="plpgsql.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="plpgsql.patch"

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 &gt; 0
      LOOP
          -- can do some processing here
!         RETURN NEXT r; -- return next row of SELECT
      END LOOP;
      RETURN;
  END
--- 1428,1434 ----
      WHERE fooid &gt; 0
      LOOP
          -- can do some processing here
!         RETURN NEXT r; -- return current row of SELECT
      END LOOP;
      RETURN;
  END

--------------040308060104090704010706--