error

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: Raw Message | Whole Thread | 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;

Responses

  • Re: error at 2019-03-29 10:49:33 from Daniel Gustafsson

Browse pgsql-docs by date

  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