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/removepoint.sql

    r2173 r2616  
    2222SELECT asewkt(removepoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 3 3 3 3, 4 4 4 4, 5 5 5 5, 6 6 6 6, 7 7 7 7)', 4)); 
    2323 
     24-- Repeat tests for new function names. 
     25--  Can't remove points from a 2-point linestring 
     26SELECT ST_removepoint('LINESTRING(0 0, 1 1)', 0); 
    2427 
     28--  Out of range indexes 
     29SELECT ST_removepoint('LINESTRING(0 0, 1 1, 2 2)', 3); 
     30SELECT ST_removepoint('LINESTRING(0 0, 1 1, 2 2)', -1); 
     31 
     32-- Removing first/last points 
     33SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0, 1 1, 2 2)', 0)); 
     34SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0, 1 1, 2 2)', 2)); 
     35 
     36-- Removing first/last points with higher dimension 
     37SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 0)); 
     38SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 2)); 
     39SELECT ST_asewkt(ST_removepoint('LINESTRINGM(0 0 0, 1 1 1, 2 2 2)', 0)); 
     40SELECT ST_asewkt(ST_removepoint('LINESTRINGM(0 0 0, 1 1 1, 2 2 2)', 2)); 
     41SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2)', 0)); 
     42SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2)', 2)); 
     43 
     44-- Removing intermediate points with higher dimension 
     45SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 3 3 3 3, 4 4 4 4, 5 5 5 5, 6 6 6 6, 7 7 7 7)', 2)); 
     46SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2, 3 3 3 3, 4 4 4 4, 5 5 5 5, 6 6 6 6, 7 7 7 7)', 4)); 
     47 
     48