15.10 - ST_Geometry Constructor (VARCHAR Form) - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Constructor method that returns a specified ST_Geometry value.

 

Argument …

Specifies …

wkt

a VARCHAR(64000) for the well-known text representation of the spatial type. The size of the wkt argument cannot exceed 64000 bytes.

When a well-known text representation is larger than 64000 bytes, use the CLOB version of the ST_Geometry constructor method.

For details on well-known text formats, see “Well-Known Text Representation” on page 194.

asrid

an optional INTEGER value for a spatial reference system identifier.

If this argument is omitted, the spatial reference system identifier is set to 0.

Use this form of ST_Geometry to construct all ST_Geometry types.

   USING (a INTEGER,
          b VARCHAR(60000))
   INSERT INTO sample_shapes VALUES (:a, NEW ST_Geometry(:b));