15.10 - ST_Geometry Constructor (CLOB 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 CLOB for the well-known text representation of the spatial type.

The maximum size of wkt is approximately 16 MB (the exact maximum is 16 MB ‑ 1 KB), allowing for a representation of approximately one million points.

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

asrid

an optional INTEGER 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 CLOB(60000))
   INSERT INTO sample_shapes VALUES (:a, NEW ST_Geometry(:b));