Postgres Pro
Downloads
Home   >   mailing lists

BUG #2211: select (1::float-1::float)*(-1) = -0 ?? - Mailing list pgsql-bugs

From Tiago D. J.
Subject BUG #2211: select (1::float-1::float)*(-1) = -0 ??
Date
Msg-id 20060125224902.897AAF0A2F@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #2211: select (1::float-1::float)*(-1) = -0 ??
Re: BUG #2211: select (1::float-1::float)*(-1) = -0 ??
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      2211
Logged by:          Tiago D. J.
Email address:      tiago@mdtestudio.com.br
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

pgsql-bugs by date:

Previous
From: "Walter Roeland"
Date:
Subject: BUG #2212: Extracting array from 2 dim array may be incorrect
Next
From: "ISHIDA Akio"
Date:
Subject: BUG #2214: release.sgml - Migration to version 8.1