ST_MeshGeomFromEWKT-PolarDB(PolarDB)-阿里云帮助中心

Constructs a meshgeom object from its extended well-known text (EWKT) representation.

Syntax

meshgeom ST_MeshGeomFromEWKT(text ewkt);

Parameters

Parameter	Description
`ewkt`	The `meshgeom` object in EWKT representation.

Example

The following example parses an EWKT string that defines a mesh geometry with a single indexed surface, then serializes it back to EWKT to verify the round-trip.

SELECT ST_AsEWKT(
    ST_MeshGeomFromEWKT(
        'SRID=4490;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1), INDEX((0,1,2),(1,2,3)))))'
    )
);

Output:

SRID=4490;MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 ),INDEX((0,1,2),(1,2,3)))))