The following bug has been logged on the website:
Bug reference: 14046
Logged by: Jarosław Stokłosa
Email address: jaroslaw(dot)stoklosa(at)nomino(dot)pl
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