Définition
ST_MultiSurface crée une entité multi-surfaces à partir d'une représentation textuelle connue.
Syntaxe
sde.st_multisurface (wkt clob, srid integer)
Type de retour
ST_MultiSurface
Exemple
CREATE TABLE msurf_test (id integer, geometry sde.st_geometry);
INSERT INTO MSURF_TEST VALUES (
1110,
sde.st_multisurface ('multipolygon (((3 3, 4 6, 5 3, 3 3),(8 24, 9 25, 1 28, 8 24), (13 33, 7 36, 1 40, 10 43, 13 33)))', 0)
);
SELECT id, sde.st_astext (geometry) MULTI_SURFACE
FROM MSURF_TEST
WHERE id = 1110;
ID MULTI_SURFACE
1110 MULTIPOLYGON (((13.00000000 33.00000000, 10.00000000
43.00000000, 1.00000000 40.00000000, 7.00000000 36.00000000,
13.00000000 33.00000000)), ((8.00000000 24.00000000, 9.00000000
25.00000000, 1.00000000 28.0000000, 8.00000000 24.00000000)),
((3.00000000 3.00000000, 5.00000000 3.00000000,
4.00000000 6.00000000, 3.00000000 3.00000000)))