123456789101112 |
- -- The following CREATE TABLE statement creates the polygon_test
- -- tables, which has a single column, p1.
- CREATE TABLE polygon_test (p1 ST_polygon);
- -- The INSERT statement converts a ring (a ST_LineString that is both
- -- closed and simple) into a ST_Polygon and inserts it into the p1 column
- -- using the ST_LineFromText function within the ST_Polygon function.
- INSERT INTO polygon_test VALUES(
- ST_Polygon(ST_LineFromText('linestring (10.01 20.03, 20.94 21.34, 35.93 10.04, 10.01 20.03)',1000))
- );
|