On 04/19/2016 04:48 PM, Tom Lane wrote:
> Pushed.  Peter, what results do you get from these tests on your
> problematic machine?

        acosd(x),
        acosd(x) IN (0,60,90,120,180) AS acosd_exact
 FROM (VALUES (-1), (-0.5), (0), (0.5), (1)) AS t(x);
-  x   | asind | asind_exact | acosd | acosd_exact
-------+-------+-------------+-------+-------------
-   -1 |   -90 | t           |   180 | t
- -0.5 |   -30 | t           |   120 | t
-    0 |     0 | t           |    90 | t
-  0.5 |    30 | t           |    60 | t
-    1 |    90 | t           |     0 | t
+  x   |        asind         | asind_exact | acosd | acosd_exact
+------+----------------------+-------------+-------+-------------
+   -1 |                  -90 | t           |   180 | t
+ -0.5 | -29.9999999999999964 | f           |   120 | t
+    0 |                    0 | t           |    90 | t
+  0.5 |  29.9999999999999964 | f           |    60 | t
+    1 |                   90 | t           |     0 | t
 (5 rows)

This is the same under the default -O2 and under -O0.



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to