st_mpolyfromtext.sql 531 B

1234567891011
  1. -- The multipolygon_test table is created with the
  2. -- single ST_MultiPolygon mpl1 column.
  3. CREATE TABLE multipolygon_test (mpl1 ST_MultiPolygon);
  4. -- The INSERT statement inserts a ST_MultiPolygon into
  5. -- the mp11 column using the ST_MPolyFromText function.
  6. INSERT INTO multipolygon_test VALUES(
  7. ST_MPolyFromText('multipolygon(((10.01 20.03,10.52 40.11,30.29 41.56,31.78 10.74,10.01 20.03),(21.23 15.74,21.34 35.21,28.94 35.35,29.02 16.83,21.23 15.74)),((40.91 10.92,40.56 20.19,50.01 21.12,51.34 9.81,40.91 10.92)))',1000)
  8. );