st_mpointfromtext.sql 482 B

12345678910111213
  1. -- The multipoint_test table is created with the gid smallint column
  2. -- that uniquely identifies the row and the mpt1 ST_MultiPoint column.
  3. CREATE TABLE multipoint_test (gid smallint,
  4. mpt1 ST_MultiPoint);
  5. -- The INSERT statement inserts a multipoint into
  6. -- the mpt1 column using the ST_MPointFromText function.
  7. INSERT INTO multipoint_test VALUES(
  8. 1,
  9. ST_MPointFromText('multipoint(10.01 20.03,10.52 40.11,30.29 41.56,31.78 10.74)',1000)
  10. );