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;