Commit0332993

committed

doc: Improve types in example

Reported-by: Nikolaus Thiel <klt@fsfe.org>

1 parent0933fce commit0332993Copy full SHA for 0332993

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -302,7 +302,7 @@ SELECT add_em(1, 2) AS answer;`
`302`	`302`	`bank account:`
`303`	`303`
`304`	`304`	`<programlisting>`
`305`		`-CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNSinteger AS $$`
	`305`	`+CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNSnumeric AS $$`
`306`	`306`	`UPDATE bank`
`307`	`307`	`SET balance = balance - debit`
`308`	`308`	`WHERE accountno = tf1.accountno;`
`@@ -333,7 +333,7 @@ SELECT tf1(17, 100.0);`
`333`	`333`	`is:`
`334`	`334`
`335`	`335`	`<programlisting>`
`336`		`-CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNSinteger AS $$`
	`336`	`+CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNSnumeric AS $$`
`337`	`337`	`UPDATE bank`
`338`	`338`	`SET balance = balance - debit`
`339`	`339`	`WHERE accountno = tf1.accountno;`
`@@ -345,7 +345,7 @@ $$ LANGUAGE SQL;`
`345`	`345`	`The same thing could be done in one command using <literal>RETURNING</>:`
`346`	`346`
`347`	`347`	`<programlisting>`
`348`		`-CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNSinteger AS $$`
	`348`	`+CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNSnumeric AS $$`
`349`	`349`	`UPDATE bank`
`350`	`350`	`SET balance = balance - debit`
`351`	`351`	`WHERE accountno = tf1.accountno`

Comments

(0)