/rtmp/diff

text/x-diff

Download

Patch

Format: context

File	+	−
doc/src/sgml/plpgsql.sgml	3	4

Index: doc/src/sgml/plpgsql.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/plpgsql.sgml,v
retrieving revision 1.118
diff -c -c -r1.118 plpgsql.sgml
*** doc/src/sgml/plpgsql.sgml	28 Nov 2007 15:42:31 -0000	1.118
--- doc/src/sgml/plpgsql.sgml	28 Nov 2007 20:11:15 -0000
***************
*** 133,141 ****
  
      <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
       evaluating a query.
      </para>
--- 133,140 ----
  
      <para>
       <application>PL/pgSQL</> functions can also be declared to return
!      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>
***************
*** 1428,1434 ****
      WHERE fooid &gt; 0
      LOOP
          -- can do some processing here
!         RETURN NEXT r; -- return next row of SELECT
      END LOOP;
      RETURN;
  END
--- 1427,1433 ----
      WHERE fooid &gt; 0
      LOOP
          -- can do some processing here
!         RETURN NEXT r; -- return current row of SELECT
      END LOOP;
      RETURN;
  END