ST_MLineFromShape |
|
Release 9.3 |
NOTE: Spatial type for PostgreSQL only
st_mlinefromshape (esri_shape bytea, srid integer)
CREATE TABLE sample_mlines (id integer unique, geometry st_geometry, shape bytea);
INSERT INTO sample_mlines (id, geometry) VALUES (
10,
st_multilinestring ('multilinestring ((61 2, 64 3, 65 6), (58 4, 59 5, 61 8), (69 3, 67 4, 66 7, 68 9))', 0)
);
UPDATE sample_mlines
SET shape = st_asshape (geometry)
WHERE id = 10;
SELECT id, st_astext (st_mlinefromshape (shape)) AS MULTI_LINE_STRING
FROM sample_mlines
WHERE id = 10;
id multi_line_string
10 MULTILINESTRING ((61 2, 64 3, 65 6), (58 4, 59 5,
61 8), (69 3, 67 4, 66 7, 68 9 ))