Обсуждение: Re: [webmaster] Documentation Error: Ceiling, Floor

Hi Patrick,

> On May 3, 2016, at 5:00 AM, patrick s. <patrick_gis@gmx.net> wrote:
>
> Dear PostgreSQL developers and webmasters
>
> It appears that the documentation of the mathematical functions "ceiling" and "floor" are wrong (inverted).
>
> result is correct and as one would expect::
> select ceiling(43.8); =>44
> select floor(43.8);  =>43
>
> 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

This should be sent to pgsql-docs (which I have CC’d)

Thanks!

Jonathan

Hi Patrick,

> On May 3, 2016, at 10:52 AM, patrick s. <patrick_gis@gmx.net> wrote:
>
> Thanks, Jonathan
>
> Didn't see whom to contact on the PG-Pages, but wanted to help.
>
> Cheers, P

Not a problem! I wanted to make sure the correct people saw it :-)

Best,

Jonathan


> On 03.05.2016 16:38, Jonathan S. Katz wrote:
>> Hi Patrick,
>>
>>> On May 3, 2016, at 5:00 AM, patrick s. <patrick_gis@gmx.net> wrote:
>>>
>>> Dear PostgreSQL developers and webmasters
>>>
>>> It appears that the documentation of the mathematical functions "ceiling" and "floor" are wrong (inverted).
>>>
>>> result is correct and as one would expect::
>>> select ceiling(43.8); =>44
>>> select floor(43.8);  =>43
>>>
>>> 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
>> This should be sent to pgsql-docs (which I have CC’d)
>>
>> Thanks!
>>
>> Jonathan
>>
>

[ 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

Thanks, Jonathan

Didn't see whom to contact on the PG-Pages, but wanted to help.

Cheers, P



On 03.05.2016 16:38, Jonathan S. Katz wrote:
> Hi Patrick,
>
>> On May 3, 2016, at 5:00 AM, patrick s. <patrick_gis@gmx.net> wrote:
>>
>> Dear PostgreSQL developers and webmasters
>>
>> It appears that the documentation of the mathematical functions "ceiling" and "floor" are wrong (inverted).
>>
>> result is correct and as one would expect::
>> select ceiling(43.8); =>44
>> select floor(43.8);  =>43
>>
>> 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
> This should be sent to pgsql-docs (which I have CC’d)
>
> Thanks!
>
> Jonathan
>

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