[postgis-tickets] r15712 - #3844 Update docs to match new = operator behaviour
Paul Ramsey
pramsey at cleverelephant.ca
Wed Sep 13 13:03:08 PDT 2017
Author: pramsey
Date: 2017-09-13 13:03:07 -0700 (Wed, 13 Sep 2017)
New Revision: 15712
Modified:
trunk/doc/reference_operator.xml
Log:
#3844 Update docs to match new = operator behaviour
Modified: trunk/doc/reference_operator.xml
===================================================================
--- trunk/doc/reference_operator.xml 2017-09-13 17:22:03 UTC (rev 15711)
+++ trunk/doc/reference_operator.xml 2017-09-13 20:03:07 UTC (rev 15712)
@@ -963,27 +963,25 @@
<refsection>
<title>Description</title>
- <para>The <varname>=</varname> operator returns <varname>TRUE</varname> if the bounding box of geometry/geography A
- is the same as the bounding box of geometry/geography B. PostgreSQL uses the =, <, and > operators defined for geometries to
+ <para>The <varname>=</varname> operator returns <varname>TRUE</varname> if the coordinates and coordinate order geometry/geography A
+ are the same as the coordinates and coordinate order of geometry/geography B. PostgreSQL uses the =, <, and > operators defined for geometries to
perform internal orderings and comparison of geometries (ie. in a GROUP BY or ORDER BY clause).</para>
- <warning>
- <para>This is cause for a lot of confusion. When you compare geometryA =
- geometryB it will return true even when the geometries are clearly
- different IF their bounding boxes are the same. To check for true
- equality use <xref linkend="ST_OrderingEquals" /> or <xref
- linkend="ST_Equals" /></para>
- </warning>
+ <note>
+ <para>Only geometry/geography that are exactly equal in all respects,
+ with the same coordinates, in the same order, are considered
+ equal by this operator. For "spatial equality", that ignores
+ things like coordinate order, and can detect features that
+ cover the same spatial area with different representations,
+ use <xref linkend="ST_OrderingEquals" />
+ or <xref linkend="ST_Equals" /></para>
+ </note>
<caution><para>This operand will NOT make use of any indexes that may be available on the
- geometries.</para></caution>
+ geometries. For an index assisted exact equality test, combine = with &&.</para></caution>
<para>&curve_support;</para>
<para>&P_support;</para>
- <para>Changed: 2.0.0 , the bounding box of geometries was changed to use double precision instead of float4 precision of
- prior. The side effect of this is that in particular points in prior versions that were a little different may have returned
- true in prior versions and false in 2.0+ since their float4 boxes would be the same but there float8 (double precision), would be
- different.</para>
</refsection>
More information about the postgis-tickets
mailing list