diff options
| -rw-r--r-- | doc/src/sgml/plpgsql.sgml | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index 75c8acdbd79..3b2b49d09be 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -1694,13 +1694,13 @@ CREATE TABLE foo (fooid INT, foosubid INT, fooname TEXT); INSERT INTO foo VALUES (1, 2, 'three'); INSERT INTO foo VALUES (4, 5, 'six'); -CREATE OR REPLACE FUNCTION getAllFoo() RETURNS SETOF foo AS +CREATE OR REPLACE FUNCTION get_all_foo() RETURNS SETOF foo AS $BODY$ DECLARE r foo%rowtype; BEGIN - FOR r IN SELECT * FROM foo - WHERE fooid > 0 + FOR r IN + SELECT * FROM foo WHERE fooid > 0 LOOP -- can do some processing here RETURN NEXT r; -- return current row of SELECT @@ -1710,7 +1710,7 @@ END $BODY$ LANGUAGE plpgsql; -SELECT * FROM getallfoo(); +SELECT * FROM get_all_foo(); </programlisting> </para> |