Show
Ignore:
Timestamp:
06/04/07 16:06:28 (5 years ago)
Author:
mleslie
Message:

Added versions of functions with standard ST (Spatial Type) prefixes to any functions that were lacking them. Updated the regression tests to include the new functions.

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/regress/regress_proj.sql

    r2111 r2616  
    3636SELECT 8,AsEWKT(transform(GeomFromEWKT('SRID=1000002;POINT(0 0)'),1000002)); 
    3737 
     38-- Repeat all tests with the new function names. 
     39--- test #0: NULL values 
     40SELECT 0,coalesce(ST_AsText(ST_transform(NULL, 1000001)),'EMPTY'); 
     41 
     42--- test #1: a simple projection 
     43SELECT 1,ST_AsEWKT(ST_SnapToGrid(ST_transform(ST_GeomFromEWKT('SRID=1000002;POINT(16 48)'),1000001),10)); 
     44 
     45--- test #2: same in 3D 
     46SELECT 2,ST_AsEWKT(ST_SnapToGrid(ST_transform(ST_GeomFromEWKT('SRID=1000002;POINT(16 48 171)'),1000001),10)); 
     47 
     48--- test #3: same in 4D 
     49SELECT 3,ST_AsEWKT(ST_SnapToGrid(ST_transform(ST_GeomFromEWKT('SRID=1000002;POINT(16 48 171 -500)'),1000001),10)); 
     50 
     51--- test #4: LINESTRING projection, 2 points 
     52SELECT 4,ST_AsEWKT(ST_SnapToGrid(ST_transform(ST_GeomFromEWKT('SRID=1000002;LINESTRING(16 48, 16 49)'),1000001),10)); 
     53 
     54--- test #5: LINESTRING projection, 2 points, 4D 
     55SELECT 5,ST_AsEWKT(ST_SnapToGrid(ST_transform(ST_GeomFromEWKT('SRID=1000002;LINESTRING(16 48 0 0, 16 49 0 0)'),1000001),10)); 
     56 
     57--- test #6: re-projecting a projected value 
     58SELECT 6,round(ST_X(ST_transform(ST_transform(ST_GeomFromEWKT('SRID=1000002;POINT(16 48)'),1000001), 1000002))::numeric,8),round(ST_Y(ST_transform(ST_transform(ST_GeomFromEWKT('SRID=1000002;POINT(16 48)'),1000001), 1000002))::numeric,8); 
     59 
     60--- test #7: Should yield an error since input SRID is unknown 
     61SELECT ST_transform(ST_GeomFromEWKT('SRID=-1;POINT(0 0)'),1000002); 
     62 
     63--- test #8: Transforming to same SRID 
     64SELECT 8,ST_AsEWKT(ST_transform(ST_GeomFromEWKT('SRID=1000002;POINT(0 0)'),1000002)); 
     65 
    3866DELETE FROM spatial_ref_sys WHERE srid >= 1000000; 
    3967