From f712995f20cca1a42ef0d44146f2fe5a4ca19b7c Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Fri, 20 Jan 2012 08:12:06 +0000 Subject: [PATCH] Revert "remove ~= from documentation -- we don't want people using this operator" This reverts r8799 git-svn-id: http://svn.osgeo.org/postgis/trunk@8885 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_operator.xml | 72 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 72 insertions(+) diff --git a/doc/reference_operator.xml b/doc/reference_operator.xml index 3031d3e03..cc6da36a5 100644 --- a/doc/reference_operator.xml +++ b/doc/reference_operator.xml @@ -991,6 +991,78 @@ FROM , + + + + ~= + + Returns TRUE if A's bounding box is the same as B's. + + + + + + + boolean ~= + + + geometry + + A + + + + geometry + + B + + + + + + + Description + + The ~= operator returns TRUE if the bounding box of geometry/geography A + is the same as the bounding box of geometry/geography B. + + This operand will make use of any indexes that may be available on the + geometries. + + Availability: 1.5.0 changed behavior + &P_support; + + + This operator has changed behavior in PostGIS 1.5 + from testing for actual geometric equality to only + checking for bounding box equality. To complicate things + it also depends on if you have done a hard or soft upgrade + which behavior your database has. To find out which behavior + your database has you can run the query below. + To check for true equality use or and to check for bounding box equality ; + operator is a safer option. + + + + + Examples + + +select 'LINESTRING(0 0, 1 1)'::geometry ~= 'LINESTRING(0 1, 1 0)'::geometry as equality; + equality | +-----------------+ + t | + + The above can be used to test if you have the new or old behavior of ~= operator. + + + See Also + , , + + -- 2.40.0