Constructs a curve polygon from a text representation.
NEW ST_CurvePolygon(text-representation[, srid])
text-representation
LONG VARCHAR
A string containing the text representation of a curve polygon. The input can be in any supported text input format, including WKT or EWKT.
srid
INT
The SRID of the result. If not specified, the default is 0.
Constructs a curve polygon from a character string representation. The database server determines the input format by inspecting the provided string.
SQL/MM (ISO/IEC 13249-3: 2006) 8.2.2
The following returns CurvePolygon (CompoundCurve (CircularString (-5 -5, 0 -5, 5 -5), (5 -5, 0 5, -5 -5)))
SELECT NEW ST_CurvePolygon('CurvePolygon (CompoundCurve (CircularString (-5 -5, 0 -5, 5 -5), (5 -5, 0 5, -5 -5)))')
The following example shows a curvepolygon with a circle as an outer ring and a triangle inner ring.
SELECT NEW ST_CurvePolygon('CurvePolygon ( CircularString (2 0, 5 3, 2 0), (3 1, 4 2, 5 1, 3 1) )') cpoly