BUG #3677: ceil/floor not working as expected

From: "Aleksander Machniak" <alec(at)alec(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3677: ceil/floor not working as expected
Date: 2007-10-15 13:31:11
Message-ID: 200710151331.l9FDVBcC049527@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3677
Logged by: Aleksander Machniak
Email address: alec(at)alec(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Doug Bedell 2007-10-15 13:53:26 BUG #3678: Folder Windows Don't Open Properly
Previous Message Dave Page 2007-10-15 08:24:17 Re: BUG #3676: README.TXT is duff gen