Re: [BUGS] BUG #3677: ceil/floor not working as expected

2007-10-15 Thread Heikki Linnakangas
Aleksander Machniak wrote: > 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. The underlying issue is that integer divided by an integer yields an integer, so 4/10 = 0. No, it's not going to be changed in Postgr

[BUGS] BUG #3677: ceil/floor not working as expected

2007-10-15 Thread Aleksander Machniak
The following bug has been logged online: Bug reference: 3677 Logged by: Aleksander Machniak Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: linux Description:ceil/floor not working as expected Details: ceil(0.4) != ceil(4/10) It's conf