Subject: Re: [webmaster] Documentation Error: Ceiling, Floor
To: Tom Lane <tgl@sss.pgh.pa.us>, "Jonathan S. Katz" <jkatz@postgresql.org>
References: <5728689A.407@gmx.net>
 <6FB5E713-894C-4C8C-A5C0-7FB16000C2F5@postgresql.org>
 <3482.1462289176@sss.pgh.pa.us>
Cc: pgsql-docs@postgresql.org
From: "patrick s." <patrick_gis@gmx.net>
Message-ID: <5728C560.2010305@gmx.net>
Date: Tue, 3 May 2016 17:36:00 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.6.0
MIME-Version: 1.0
In-Reply-To: <3482.1462289176@sss.pgh.pa.us>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

Thanks, Tom.

Can confirm this. My error was that examples for "round" are using 
positive values and examples of "ceiling"/"floor" are using negative 
ones. Maybe misleading on a fast look.

Sorry for wasting your time, guys!

Patrick


On 03.05.2016 17:26, Tom Lane wrote:
> [ trimming 100%-inappropriate crossposts ]
>
>> On May 3, 2016, at 5:00 AM, patrick s. <patrick_gis@gmx.net> wrote:
>>> documentation is misleading:
>>> select ceiling(43.8); =>43
>>> select floor(43.8); =>44
>>>
>>> found in:
>>> http://www.postgresql.org/docs/9.1/static/functions-math.html
>>> http://www.postgresql.org/docs/7.4/static/functions-math.html
> AFAICS, those examples refer to -43.8 not 43.8, and are quite correct.
>
> 			regards, tom lane


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