From cd80d8ea2efa69f4ac2e7eb08abf6ebd41a50eaa Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sun, 6 Jul 2008 07:22:51 +0000 Subject: [PATCH] fixed ST_Dimension example, flipped order of conditions in WHERE on some examples (in later versions of PostgreSQL since we don't have our costs right - the planner may choose to process in order of conditions git-svn-id: http://svn.osgeo.org/postgis/trunk@2827 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/postgis.xml | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) diff --git a/doc/postgis.xml b/doc/postgis.xml index a7f0f677c..6e7f9e464 100644 --- a/doc/postgis.xml +++ b/doc/postgis.xml @@ -2052,8 +2052,7 @@ SELECT FROM bc_roads AS r, bc_municipality AS m -WHERE ST_Intersects(r.the_geom, m.the_geom) - AND m.name = 'PRINCE GEORGE'; +WHERE m.name = 'PRINCE GEORGE' AND ST_Intersects(r.the_geom, m.the_geom); @@ -2069,9 +2068,8 @@ WHERE ST_Intersects(r.the_geom, m.the_geom) FROM bc_roads r, bc_municipality m -WHERE ST_Contains(m.the_geom, r.the_geom) - AND r.name = 'Douglas St' - AND m.name = 'VICTORIA'; +WHERE r.name = 'Douglas St' AND m.name = 'VICTORIA' + AND ST_Contains(m.the_geom, r.the_geom) ; kilometers ------------------ @@ -3342,7 +3340,7 @@ VACUUM FULL ANALYZE mytable; and the largest dimension of the components of a GEOMETRYCOLLECTION. - select dimension('GEOMETRYCOLLECTION(LINESTRING(1 1,0 0),POINT(0 0)'); + SELECT ST_dimension('GEOMETRYCOLLECTION(LINESTRING(1 1,0 0),POINT(0 0))'); dimension ----------- 1 -- 2.50.1