postgis/regress/core/chaikin.sql
Raúl Marín Rodríguez ce7c214c9f Fix ST_SnapToGrid output having an outdated bbox
References #4495
Closes https://github.com/postgis/postgis/pull/473



git-svn-id: http://svn.osgeo.org/postgis/trunk@17798 b70326c6-7e19-0410-871a-916f4a2858ee
2019-09-02 11:55:46 +00:00

13 lines
736 B
SQL

SELECT '1', ST_astext(ST_ChaikinSmoothing('LINESTRING(0 0, 8 8, 0 16)'));
SELECT '2', ST_astext(ST_ChaikinSmoothing('LINESTRING(0 0, 8 8, 0 16)',10));
SELECT '3', ST_astext(ST_ChaikinSmoothing('LINESTRING(0 0, 8 8, 0 16)',0));
SELECT '4', ST_astext(ST_ChaikinSmoothing('LINESTRING(0 0, 8 8, 0 16)',2));
SELECT '5', ST_astext(ST_ChaikinSmoothing('POINT(0 0)'));
SELECT '6', ST_astext(ST_ChaikinSmoothing('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(1 1, 1 3, 1 5), POLYGON((5 5, 5 10, 10 10, 10 5, 5 5), (6 6, 6 7, 7 7, 7 6, 6 6 )))', 2, 't'));
-- The geometry bbox is updated
WITH geom AS
(
SELECT ST_ChaikinSmoothing('POLYGON((0 0, 8 8, 0 16, 0 0))') AS g
)
SELECT '7', ST_AsText(g) as geometry, postgis_getbbox(g) AS box from geom;