"Tiago D. J." <[EMAIL PROTECTED]> writes: > But run this query : > select (1::float-1::float)*(-1)
> it returns -0
AFAIK this is correct behavior per the IEEE floating-point-math spec.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
