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