Subject: Re: Bad return type in example
To: klt@fsfe.org, pgsql-docs@postgresql.org
References: <f37673c3-8786-b493-e244-93b7dc28028e@fsfe.org>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <2e439e4b-5033-29e7-eec3-2651fb53c9e6@2ndquadrant.com>
Date: Fri, 9 Jun 2017 19:51:25 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:52.0)
 Gecko/20100101 Thunderbird/52.1.1
MIME-Version: 1.0
In-Reply-To: <f37673c3-8786-b493-e244-93b7dc28028e@fsfe.org>
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

On 3/8/17 04:00, Nikolaus Thiel wrote:
>   * postgresql-9.6-A4.pdf, page 891
>   * https://www.postgresql.org/docs/9.6/static/xfunc-sql.html#XFUNC-SQL-BASE-FUNCTIONS
> 
> Dear Doc Writers,
> 
> Would it not be better to change the return type of the following two
> sample functions to numeric ?

fixed

> 
> 
> 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;

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs