pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Guillaume Lelarge <guillaume@lelarge.info>
To: pgsql-docs@postgresql.org
Subject: Two fixes for plpgsql.sgml
Date: Wed, 28 Nov 2007 08:17:33 +0100
Message-ID: <474D160D.5090908@lelarge.info> (raw)

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

Attachments:

plpgsql.patch (text/x-patch, 1.5K) download
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

view thread (9+ messages)  latest in thread

Message-ID: <474D160D.5090908@lelarge.info>
Permalink:  ../474D160D.5090908@lelarge.info/
Also on:    postgresql.org/message-id/474D160D.5090908@lelarge.info

copy link · copy postgr.es · copy git am

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: guillaume@lelarge.info
  Subject: Re: Two fixes for plpgsql.sgml
  In-Reply-To: <474D160D.5090908@lelarge.info>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox