Request a Demo
Home   >   mailing lists

BUG #14046: Bad mathematical rules for 0 cast - Mailing list pgsql-bugs

From [email protected]
Subject BUG #14046: Bad mathematical rules for 0 cast
Date
Msg-id [email protected]
Whole thread Raw
Responses Re: BUG #14046: Bad mathematical rules for 0 cast
Re: BUG #14046: Bad mathematical rules for 0 cast
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      14046
Logged by:          Jarosław Stokłosa
Email address:      [email protected]
PostgreSQL version: 9.4.5
Operating system:    x86_64-redhat-linux-gnu
Description:

Below query should return 2 times TRUE.

SELECT cast('+0' as FLOAT) = cast('-0' as FLOAT), cast('+0' as FLOAT)::TEXT
= cast('-0' as FLOAT)::TEXT

+0 and -0 should be casted to +0 or 0.

Regards

pgsql-bugs by date:

Previous
From: [email protected]
Date:
Subject: BUG #14045: ** BUILD FAILED **
Next
From: Michael Paquier
Date:
Subject: Re: Breakage with VACUUM ANALYSE + partitions