aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2002-11-08 20:26:12 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2002-11-08 20:26:12 +0000
commitf2ef470196530e862b01c95e3b599e29102c887e (patch)
treed35a6e6fa097e193aaf0d64b413f5bdc118f69e3 /doc/src
parentbea4792125389bb68e043ac38b0fed8790d42484 (diff)
downloadpostgresql-f2ef470196530e862b01c95e3b599e29102c887e.tar.gz
postgresql-f2ef470196530e862b01c95e3b599e29102c887e.zip
Update discussion of floating-point problems in regression tests.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/regress.sgml39
1 files changed, 9 insertions, 30 deletions
diff --git a/doc/src/sgml/regress.sgml b/doc/src/sgml/regress.sgml
index 2c5263b075a..193c8c256ed 100644
--- a/doc/src/sgml/regress.sgml
+++ b/doc/src/sgml/regress.sgml
@@ -1,4 +1,4 @@
-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/regress.sgml,v 1.29 2002/10/12 16:31:55 petere Exp $ -->
+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/regress.sgml,v 1.30 2002/11/08 20:26:12 tgl Exp $ -->
<chapter id="regress">
<title id="regress-title">Regression Tests</title>
@@ -264,47 +264,26 @@ PGTZ='PST8PDT7,M04.01.0,M10.05.03'; export PGTZ
Some of the tests involve computing 64-bit (<type>double
precision</type>) numbers from table columns. Differences in
results involving mathematical functions of <type>double
- precision</type> columns have been observed. The float8 and
- geometry tests are particularly prone to small differences across
- platforms, or even with different compiler optimization options.
+ precision</type> columns have been observed. The <literal>float8</> and
+ <literal>geometry</> tests are particularly prone to small differences
+ across platforms, or even with different compiler optimization options.
Human eyeball comparison is needed to determine the real
significance of these differences which are usually 10 places to
the right of the decimal point.
</para>
<para>
+ Some systems display minus zero as <literal>-0</>, while others
+ just show <literal>0</>.
+ </para>
+
+ <para>
Some systems signal errors from <function>pow()</function> and
<function>exp()</function> differently from the mechanism
expected by the current <productname>PostgreSQL</productname>
code.
</para>
</sect2>
-
- <sect2>
- <title>Polygon differences</title>
-
- <para>
- Several of the tests involve operations on geographic data about
- the Oakland/Berkeley, California street map. The map data is expressed as
- polygons whose vertices are represented as pairs of <type>double
- precision</type> numbers (decimal latitude and
- longitude). Initially, some tables are created and loaded with
- geographic data, then some views are created that join two
- tables using the polygon intersection operator
- (<literal>##</literal>), then a select is done on the view.
- </para>
-
- <para>
- When comparing the results from different platforms, differences
- occur in the 2nd or 3rd place to the right of the decimal
- point. The SQL statements where these problems occur are the
- following:
-<programlisting>
-SELECT * from street;
-SELECT * from iexit;
-</programlisting>
- </para>
- </sect2>
<sect2>
<title>Row ordering differences</title>