Changeset: c4d793bed0e8 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c4d793bed0e8
Added Files:
geom/sql/Tests/pg_regression/Tests/removepoint.sql
Modified Files:
geom/sql/Tests/pg_regression/Tests/All
Branch: geo
Log Message:
pg_regress: removepoint
diffs (40 lines):
diff --git a/geom/sql/Tests/pg_regression/Tests/All
b/geom/sql/Tests/pg_regression/Tests/All
--- a/geom/sql/Tests/pg_regression/Tests/All
+++ b/geom/sql/Tests/pg_regression/Tests/All
@@ -15,4 +15,6 @@
#regress_lrs #Unknown Functions: st_locatealong, st_locatebetween,
ST_LineLocatePoint, st_geomfromewkt, st_linesubstring, st_lineinterpolatepoint
+#removepoint #Unknown Functions: st_removepoint
+
removeTmpFiles
diff --git a/geom/sql/Tests/pg_regression/Tests/removepoint.sql
b/geom/sql/Tests/pg_regression/Tests/removepoint.sql
new file mode 100644
--- /dev/null
+++ b/geom/sql/Tests/pg_regression/Tests/removepoint.sql
@@ -0,0 +1,25 @@
+-- Repeat tests for new function names.
+-- Can't remove points from a 2-point linestring
+SELECT ST_removepoint('LINESTRING(0 0, 1 1)', 0);
+
+-- Out of range indexes
+SELECT ST_removepoint('LINESTRING(0 0, 1 1, 2 2)', 3);
+SELECT ST_removepoint('LINESTRING(0 0, 1 1, 2 2)', -1);
+
+-- Removing first/last points
+SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0, 1 1, 2 2)', 0));
+SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0, 1 1, 2 2)', 2));
+
+-- Removing first/last points with higher dimension
+SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 0));
+SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 2));
+SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 0));
+SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0, 1 1 1, 2 2 2)', 2));
+SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2)', 0));
+SELECT ST_asewkt(ST_removepoint('LINESTRING(0 0 0 0, 1 1 1 1, 2 2 2 2)', 2));
+
+-- Removing intermediate points with higher dimension
+SELECT 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));
+SELECT 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));
+
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
