diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2017-06-09 19:49:18 -0400 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2017-06-09 19:49:18 -0400 |
| commit | 0332993c4e14f13b211f41535f77aadb305fd354 (patch) | |
| tree | 7f9de4c578d2b22db36b7aa22d90502682573a1a | |
| parent | 0933fcee9851eb2afcd41db1ee4425153f4cbdd3 (diff) | |
| download | postgresql-0332993c4e14f13b211f41535f77aadb305fd354.tar.gz postgresql-0332993c4e14f13b211f41535f77aadb305fd354.zip | |
doc: Improve types in example
Reported-by: Nikolaus Thiel <klt@fsfe.org>
| -rw-r--r-- | doc/src/sgml/xfunc.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/xfunc.sgml b/doc/src/sgml/xfunc.sgml index 10e3c0cef9f..05f4312bf3e 100644 --- a/doc/src/sgml/xfunc.sgml +++ b/doc/src/sgml/xfunc.sgml @@ -302,7 +302,7 @@ SELECT add_em(1, 2) AS answer; bank account: <programlisting> -CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNS integer AS $$ +CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNS numeric AS $$ UPDATE bank SET balance = balance - debit WHERE accountno = tf1.accountno; @@ -333,7 +333,7 @@ SELECT tf1(17, 100.0); is: <programlisting> -CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNS integer AS $$ +CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNS numeric AS $$ UPDATE bank SET balance = balance - debit WHERE accountno = tf1.accountno; @@ -345,7 +345,7 @@ $$ LANGUAGE SQL; The same thing could be done in one command using <literal>RETURNING</>: <programlisting> -CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNS integer AS $$ +CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNS numeric AS $$ UPDATE bank SET balance = balance - debit WHERE accountno = tf1.accountno |