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 confusing. Ceil(4/10::numeric) is ok, but in mysql I don't need keep casting in mind in this case. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate