Changes between Version 5 and Version 6 of DevWikiEmptyGeometry

Timestamp:

Oct 6, 2009, 10:34:28 AM (15 years ago)

Author:

robe

Comment:

—

DevWikiEmptyGeometry

@@ -2 +2 @@
 
  * ST_Union(geometry, empty) == geometry
+
+{{{
+ 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() => POINT(1 2)
+}}}
+
+   
  * ST_Union(empty, empty) == empty
+{{{
+ SQL Server 2008: SELECT Geometry::STGeomFromText('POLYGON(EMPTY)',4326).STUnion(Geometry::STGeomFromText('POLYGON EMPTY',4326)) => POINT (1 2)
+   
+}}}
  * ST_Difference(geometry, empty) == geometry
  * ST_Difference(empty, geometry) == empty