Changeset 6473 for trunk/regress/regress.sql
- Timestamp:
- 12/22/10 10:42:38 (17 months ago)
- Files:
-
- 1 modified
-
trunk/regress/regress.sql (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/regress/regress.sql
r6467 r6473 187 187 select '110', ST_NRings('MULTIPOLYGON( ((0 0, 10 0, 10 10, 0 10, 0 0)),( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7 , 5 7, 5 5) ) ,( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7, 5 7, 5 5),(1 1,2 1, 2 2, 1 2, 1 1) ) )'::GEOMETRY) as value; 188 188 189 select '111', ST_mem_size( dropBBOX('MULTIPOLYGON( ((0 0, 10 0, 10 10, 0 10, 0 0)),( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7 , 5 7, 5 5) ) ,( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7, 5 7, 5 5),(1 1,2 1, 2 2, 1 2, 1 1) ) )'::GEOMETRY)) as value;189 select '111', ST_mem_size(PostGIS_DropBBOX('MULTIPOLYGON( ((0 0, 10 0, 10 10, 0 10, 0 0)),( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7 , 5 7, 5 5) ) ,( (0 0, 10 0, 10 10, 0 10, 0 0),(5 5, 7 5, 7 7, 5 7, 5 5),(1 1,2 1, 2 2, 1 2, 1 1) ) )'::GEOMETRY)) as value; 190 190 191 191 select '112',ST_NumGeometries('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING( 1 1 , 2 2, 3 3),MULTIPOINT(1 1, 2 2))'::GEOMETRY) as value; … … 215 215 select '128',a ~ b from TEST; 216 216 217 select '129', ST_mem_size( dropBBOX(a)), ST_mem_size(dropBBOX(b)) from TEST;217 select '129', ST_mem_size(PostGIS_DropBBOX(a)), ST_mem_size(PostGIS_DropBBOX(b)) from TEST; 218 218 219 219 select '131', ST_X('POINT(1 2)'); … … 242 242 select '148', ST_AsText(ST_segmentize('LINESTRING(0 0, 10 0)', 5)); 243 243 244 select '149', ST_AsText( segmentize('GEOMETRYCOLLECTION EMPTY', 0.5));244 select '149', ST_AsText(ST_segmentize('GEOMETRYCOLLECTION EMPTY', 0.5)); 245 245 246 246 select '150', ST_AsEWKT(ST_force_collection(ST_setsrid('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'::geometry, 6)));
