Thread: 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
$$
>     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