Returns an ST_GeomCollection value, which is transformed from a LONG VARCHAR value containing the WKT representation of an ST_GeomCollection
Syntax[DBO.]ST_GeomCollFromTxt(wkt[, srid])
Parameters| Name | Type | Description |
|---|---|---|
|
wkt |
LONG VARCHAR |
The WKT representation. |
|
srid |
INT |
The SRID of the result. If not specified, the default is 0. |
ReturnsST_GeomCollection Returns an ST_GeomCollection value created from the input string.
The spatial reference system identifier of the result is the given by parameter srid.
The ST_GeomCollFromTxt function is not present by default in newly created databases. Use the sa_install_feature system procedure to install the spatial SQL compatibility functions. See sa_install_feature system procedure.
RemarksThe ST_GeomCollFromTxt function is equivalent to the following:
CREATE FUNCTION DBO.ST_GeomCollFromTxt( wkt LONG VARCHAR, srid INT DEFAULT 0 )
RETURNS ST_GeomCollection
BEGIN
DECLARE geo ST_Geometry;
set geo = ST_Geometry::ST_GeomFromText( wkt, srid );
RETURN CAST( geo AS ST_GeomCollection);
END |
See also Standards and compatibilitySQL/MM (ISO/IEC 13249-3: 2006) 9.1.6
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |