Re: [webmaster] Documentation Error: Ceiling, Floor

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

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

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

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

[ 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

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

-------- Forwarded Message --------
Subject: [CORE] Documentation Error: Ceiling, Floor
Date: Tue, 3 May 2016 11:00:10 +0200
From: patrick s. <patrick_gis@gmx.net>
To: webmaster@postgresql.org, pgsql-core@postgresql.org

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

Cheers,
Patrick

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

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