ST_AsExtText function [Spatial]

Returns a binary string representing the specified geometry. The output format is EWKT.

Syntax

ST_AsExtText(geometry-expression)

Returns

Example

The following statement returns the result SRID=4326;Point (1 2), with the SRID included as a prefix:

SELECT ST_AsExtText(ST_Point(1.0, 2.0, 4326))

The ST_AsExtText() function is implicitly invoked when converting geometries to VARCHAR types. For example, the following statement returns the result SRID=4326;Point(1 2):

SELECT CAST(ST_Point(1.0, 2.0, 4326) AS VARCHAR(25))

Discuter à propos de cette page dans DocCommentXchange.