st_geometry_astext_format option

The list of values supported for this option is identical to the list of parameters (including sub-parameters) documented for the ST_AsText method. See ST_AsText method for type ST_Geometry.

WKT

This option is used to determine how a geometry is converted to text. The following are the two main contexts in which the option is used:

fetching a value as text from a client application
Executing a CAST statement. For example: CAST( geometry-expression AS LONG VARCHAR )

Assignments from geometry types to CHAR types give an error in contexts other than fetching from a client application and the CAST statement. For example, you cannot call a function or procedure that takes a CHAR parameter and pass a geometry, nor can you assign a geometry to a LONG VARCHAR variable.

st_geometry_astext_format option

Allowed values

Default

Remarks

See also