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

Constructs a meshgeom object from its HEXEWKB (hex-encoded Extended Well-Known Binary) representation.

Syntax

meshgeom ST_MeshGeomFromHexEWKB(text hexewkb);

Parameters

Parameter	Description
`hexewkb`	The meshgeom object in HEXEWKB representation.

Example

SELECT ST_AsEWKT(ST_MeshGeomFromHexEWKB(ST_AsHexEWKB('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1), INDEX((0,1,2),(1,2,3)))))'::meshgeom)));

Output:

                                   st_asewkt
-----------------------------------------------------------------------------
 MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1),INDEX((0,1,2),1,2,3))))