Lists: | pgsql-docs |
---|
From: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
---|---|
To: | "patrick s(dot)" <patrick_gis(at)gmx(dot)net> |
Cc: | webmaster(at)postgresql(dot)org, pgsql-core(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: [webmaster] Documentation Error: Ceiling, Floor |
Date: | 2016-05-03 14:38:44 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
Hi Patrick,
> On May 3, 2016, at 5:00 AM, patrick s. <patrick_gis(at)gmx(dot)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
From: | "patrick s(dot)" <patrick_gis(at)gmx(dot)net> |
---|---|
To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
Cc: | webmaster(at)postgresql(dot)org, pgsql-core(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: [webmaster] Documentation Error: Ceiling, Floor |
Date: | 2016-05-03 14:52:36 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
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(at)gmx(dot)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
>
From: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
---|---|
To: | "patrick s(dot)" <patrick_gis(at)gmx(dot)net> |
Cc: | webmaster(at)postgresql(dot)org, pgsql-core(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: [webmaster] Documentation Error: Ceiling, Floor |
Date: | 2016-05-03 15:15:08 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
Hi Patrick,
> On May 3, 2016, at 10:52 AM, patrick s. <patrick_gis(at)gmx(dot)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(at)gmx(dot)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
>>
>
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
Cc: | "patrick s(dot)" <patrick_gis(at)gmx(dot)net>, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: [webmaster] Documentation Error: Ceiling, Floor |
Date: | 2016-05-03 15:26:16 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
[ trimming 100%-inappropriate crossposts ]
> On May 3, 2016, at 5:00 AM, patrick s. <patrick_gis(at)gmx(dot)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
From: | "patrick s(dot)" <patrick_gis(at)gmx(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: [webmaster] Documentation Error: Ceiling, Floor |
Date: | 2016-05-03 15:36:00 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | pgsql-docs |
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(at)gmx(dot)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