Thread: 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