15.10 - ST_Geometry Constructor (VARBYTE 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 …

wkb

a VARBYTE(64000) for the well-known binary representation of the spatial type. The size of wkb cannot exceed 64000 bytes.

When a WKB representation is larger than 64000 bytes, use the BLOB version of the ST_Geometry constructor method.

For details on well-known binary formats, see “Well-Known Binary Representation” on page 198.

asrid

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