4. Geospatial Data Types : MultiLinestring Data Type
 
Share this page                  
MultiLinestring Data Type
A MultiLinestring is a collection that consists of only linestrings.
Example:
Without specifying SRID:
CREATE TABLE rivers (name VARCHAR(30), path MULTILINESTRING);
With specifying SRID:
CREATE TABLE rivers (name VARCHAR(30), path MULTILINESTRING SRID 26911);
Group several rivers into a MultiLineString that represents all the rivers within a park:
CREATE TABLE rivers (id INTEGER PRIMARY KEY, path MULTILINESTRING);
INSERT INTO rivers (id, path) VALUES (1, MLINEFROMTEXT('MULTILINESTRING((0 0, 5 5),(10 10, 5 5, 0 0),(0 0, 10 10, 10 0))'));