| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | tempinout(at)ukr(dot)net |
| Subject: | error |
| Date: | 2019-03-28 14:44:52 |
| Message-ID: | 155378429268.9814.15793833671806862761@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2019-03-28 18:06:18 | Re: First SVG graphic |
| Previous Message | Liudmila Mantrova | 2019-03-28 14:01:19 | improve examples for JSON functions |