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