"Tiago D. J." <tiago(at)mdtestudio(dot)com(dot)br> 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