Postgres Pro
Downloads
Home   >   mailing lists

BUG #3677: ceil/floor not working as expected - Mailing list pgsql-bugs

From Aleksander Machniak
Subject BUG #3677: ceil/floor not working as expected
Date
Msg-id 200710151331.l9FDVBcC049527@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3677: ceil/floor not working as expected
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3677
Logged by:          Aleksander Machniak
Email address:      alec@alec.pl
PostgreSQL version: 8.2.4
Operating system:   linux
Description:        ceil/floor not working as expected
Details:

ceil(0.4) != ceil(4/10)

It's confusing. Ceil(4/10::numeric) is ok, but in mysql I don't need keep
casting in mind in this case.

pgsql-bugs by date:

Previous
From: Dave Page
Date:
Subject: Re: BUG #3676: README.TXT is duff gen
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3677: ceil/floor not working as expected