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));