diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2013-04-21 22:21:29 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2013-04-21 22:22:10 -0400 |
| commit | e7d5ffe8ea9883f1b472036dfc098d555f5cd3ea (patch) | |
| tree | 6122a62eaa2db3b5a203b1d57f8ad91e75fbbf5f | |
| parent | 53ecfddcebbf607badc678e294bf977334b79327 (diff) | |
| download | postgresql-e7d5ffe8ea9883f1b472036dfc098d555f5cd3ea.tar.gz postgresql-e7d5ffe8ea9883f1b472036dfc098d555f5cd3ea.zip | |
doc: Improve example formatting
Erwin Brandstetter
| -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> |