error
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/xfunc-sql.html
Description:
hello
i've descovered a small error - instead of integer should be numeric
https://www.postgresql.org/docs/9.6/xfunc-sql.html
CREATE FUNCTION tf1 (accountno integer, debit numeric) RETURNS integer AS
$$
Show quoted text
UPDATE bank
SET balance = balance - debit
WHERE accountno = tf1.accountno;
SELECT balance FROM bank WHERE accountno = tf1.accountno;
$$ LANGUAGE SQL;
On Thursday, March 28, 2019 3:44 PM, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/xfunc-sql.html
Description:hello
i've descovered a small error - instead of integer should be numeric
https://www.postgresql.org/docs/9.6/xfunc-sql.html
This was fixed in 0332993c4e14f13b211f41535f77aadb305fd354 but wasn't
backported, hence why it's still integer in 9.6 but numeric in 10 and
onwards.
cheers ./daniel