aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2017-06-09 19:49:18 -0400
committerPeter Eisentraut <peter_e@gmx.net>2017-06-09 19:49:18 -0400
commit0332993c4e14f13b211f41535f77aadb305fd354 (patch)
tree7f9de4c578d2b22db36b7aa22d90502682573a1a
parent0933fcee9851eb2afcd41db1ee4425153f4cbdd3 (diff)
downloadpostgresql-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.sgml6
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