ST_ToCircular method

geometry-expression.ST_ToCircular()

ST_CircularString If the geometry-expression is of type ST_CircularString, return the geometry-expression. If the geometry-expression is of type ST_CompoundCurve with a single element which is of type ST_CircularString, return that element. If the geometry-expression is a geometry collection with a single element of type ST_CircularString, return that element. If the geometry-expression is the empty set, return an empty set of type ST_CircularString. Otherwise, raise an exception condition.
The spatial reference system identifier of the result is the same as the spatial reference system of the geometry-expression.

Convert this geometry to a circularstring. The logic is equivalent to that used for CAST( geometry-expression AS ST_CircularString ).

If geometry-expression is already known to be an ST_CircularString value, it is more efficient to use TREAT( geometry-expression AS ST_CircularString ) than the ST_ToCircular method.

Note

By default, ST_ToCircular uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

SQL/MM (ISO/IEC 13249-3: 2006) 5.1.33

The following example returns the result CircularString (0 0, 1 1, 2 0).

SELECT NEW ST_CompoundCurve( 'CompoundCurve(CircularString( 0 0, 1 1, 2 0 ))' ).ST_ToCircular()

ST_ToCircular method

Syntax

Returns

Remarks

Note

See also

Standards and compatibility

Example