4. Geospatial Data Types : Two-dimensional Data Types : MultiCurve Data Type
 
Share this page                  
MultiCurve Data Type
A MultiCurve can contain between 1 to N curves of the types Linestring, CircularString, and CompoundCurve, with any combination of these types.
Examples:
Without specifying SRID:
CREATE TABLE curves (name VARCHAR(30), mcurve MULTICURVE);
With specifying SRID:
CREATE TABLE curves (name VARCHAR(30), mcurve MULTICURVE SRID 4326);
Show a collection of curves that may or may not be related:
CREATE TABLE curves (id INT, mcurve MULTICURVE);
INSERT INTO curves (id, mcurve) VALUES (1, GeomFromText('MULTICURVE((0 0, 10 10, 20 0), CIRCULARSTRING(-5 -5, 2 2, -1 -1))'));