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 PostgreSQL. You can also write "4.0/10".
In response to
pgsql-bugs by date
|Next:||From: Kevin Kuhner||Date: 2007-10-15 15:09:27|
|Subject: IPv6 Support in 8.0.3|
|Previous:||From: Doug Bedell||Date: 2007-10-15 13:53:26|
|Subject: BUG #3678: Folder Windows Don't Open Properly|