The following bug has been logged online:

Bug reference:      2211
Logged by:          Tiago D. J.
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system:   Slackware 10.2
Description:        select (1::float-1::float)*(-1) = -0 ??
Details: 

Hi people,
I think that anything * 0, or 0*anything should be zero.
But run this query :
select (1::float-1::float)*(-1)

it returns -0

Sorry, my english is so poor,
I hope that i'm helping you with this information.

Tiago

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to