From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
---|---|
To: | klt(at)fsfe(dot)org, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: Bad return type in example |
Date: | 2017-06-09 23:51:25 |
Message-ID: | 2e439e4b-5033-29e7-eec3-2651fb53c9e6@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
On 3/8/17 04:00, Nikolaus Thiel wrote:
> * postgresql-9.6-A4.pdf, page 891
> * https://www.postgresql.org/docs/9.6/static/xfunc-sql.html#XFUNC-SQL-BASE-FUNCTIONS
>
> Dear Doc Writers,
>
> Would it not be better to change the return type of the following two
> sample functions to numeric ?
fixed
>
>
> CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNS integer AS $$
> UPDATE bank
> SET balance = balance - debit
> WHERE accountno = tf1.accountno;
> SELECT balance FROM bank WHERE accountno = tf1.accountno;
> $$ LANGUAGE SQL;
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2017-06-10 00:37:16 | Re: Add client interfaces for Node.js and Go / Rename JDBC language to Java |
Previous Message | George Neuner | 2017-06-09 16:45:04 | Re: pg_upgrade --link on Windows |