Commite7d5ffe

committed

doc: Improve example formatting

Erwin Brandstetter

1 parent53ecfdd commite7d5ffeCopy full SHA for e7d5ffe

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1694,13 +1694,13 @@ CREATE TABLE foo (fooid INT, foosubid INT, fooname TEXT);`
`1694`	`1694`	`INSERT INTO foo VALUES (1, 2, 'three');`
`1695`	`1695`	`INSERT INTO foo VALUES (4, 5, 'six');`
`1696`	`1696`
`1697`		`-CREATE OR REPLACE FUNCTIONgetAllFoo() RETURNS SETOF foo AS`
	`1697`	`+CREATE OR REPLACE FUNCTIONget_all_foo() RETURNS SETOF foo AS`
`1698`	`1698`	$BODY$
`1699`	`1699`	`DECLARE`
`1700`	`1700`	`r foo%rowtype;`
`1701`	`1701`	`BEGIN`
`1702`		`- FOR r IN SELECT * FROM foo`
`1703`		`- WHERE fooid > 0`
	`1702`	`+ FOR r IN`
	`1703`	`+ SELECT * FROM fooWHERE fooid > 0`
`1704`	`1704`	`LOOP`
`1705`	`1705`	`-- can do some processing here`
`1706`	`1706`	`RETURN NEXT r; -- return current row of SELECT`
`@@ -1710,7 +1710,7 @@ END`
`1710`	`1710`	$BODY$
`1711`	`1711`	`LANGUAGE plpgsql;`
`1712`	`1712`
`1713`		`-SELECT * FROMgetallfoo();`
	`1713`	`+SELECT * FROMget_all_foo();`
`1714`	`1714`	`</programlisting>`
`1715`	`1715`	`</para>`
`1716`	`1716`

Comments

(0)