st_mlinefromtext.sql 511 B

12345678910111213
  1. -- The mlinestring_test table is created with the gid smallint column
  2. -- that uniquely identifies the row and the ml1 ST_MultiLineString column.
  3. CREATE TABLE mlinestring_test (gid smallint,
  4. ml1 ST_MultiLineString);
  5. -- The INSERT statement inserts the ST_MultiLineString with the
  6. -- ST_MLineFromText function.
  7. INSERT INTO mlinestring_test VALUES(
  8. 1,
  9. ST_MLineFromText('multilinestring((10.01 20.03,10.52 40.11,30.29 41.56,31.78 10.74),(20.93 20.81, 21.52 40.10))', 1000)
  10. )