Changes between Version 7 and Version 8 of DevWikiEmptyGeometry

Timestamp:

10/06/09 10:46:43 (16 years ago)

Author:

robe

Comment:

--

DevWikiEmptyGeometry

@@ -4 +4 @@
 
 {{{
-SQL Server 2008 geometry: SELECT Geometry::STGeomFromText('POINT(1 2)',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326))
+SQL Server 2008 geometry
+   SELECT Geometry::STGeomFromText('POINT(1 2)',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326))
      => POINT (1 2)
    
-SQL Server 2008 geography: SELECT (Geography::STGeomFromText('POINT(1 2)',4326).STUnion(Geography::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
+SQL Server 2008 geography 
+  SELECT (Geography::STGeomFromText('POINT(1 2)',4326).STUnion(Geography::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
     => POINT(1 2)
 }}}
@@ -14 +16 @@
  * ST_Union(empty, empty) == empty
 {{{
- SQL Server 2008 Geography: SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
+ SQL Server 2008 Geometry
+   SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
      => GEOMETRYCOLLECTION EMPTY
- SQL Server 2008 Geography: SELECT (Geography::STGeomFromText('POLYGON EMPTY',4326).STUnion(Geography::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
+ SQL Server 2008 Geography
+    SELECT (Geography::STGeomFromText('POLYGON EMPTY',4326).STUnion(Geography::STGeomFromText('POLYGON EMPTY',4326))).STAsText() 
       => GEOMETRYCOLLECTION EMPTY
    
@@ -25 +29 @@
  * ST_DWithin(geometry, empty, tolerance) == FALSE
  * ST_Contains(geometry, empty) == FALSE
+
+{{{
+SQL Server 2008 Geometry
+SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STContains(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
+  => 0
+}}}
+
  * ??? ST_Contains(empty, empty) == FALSE
+
+{{{
+SQL Server 2008 Geometry
+ SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STContains(Geometry::STGeomFromText('POLYGON EMPTY',4326)))
+
+}}}
+
+   
  * ST_Intersects(geometry, empty) == FALSE
+
+{{{
+SQL Server 2008 Geometry
+  SELECT (Geometry::STGeomFromText('POINT(1 3)',4326).STIntersects(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
+  => 0
+}}}
+
  * ??? ST_Intersects(empty, empty) == FALSE
+{{{
+SQL Server 2008 Geometry
+  SELECT (Geometry::STGeomFromText('POLYGON EMPTY',4326).STIntersects(Geometry::STGeomFromText('POLYGON EMPTY',4326))) 
+    => 0
+}}}
+
  * ??? ST_Disjoint(empty, empty) == FALSE
  * ??? ST_Disjoint(geometry, empty) == FALSE