Returns a specified ST_Geometry value.
|
Argument … |
Specifies … |
|
awkb |
the geometry value specified in the well-known binary (WKB) format. The data type of awkb is BLOB. The maximum size of awkb is approximately 16 MB (the exact maximum is 16 MB ‑ 1 KB), allowing for a representation of approximately one million points. For details on WKB formats, see “Well-Known Binary Representation” on page 198. |
Returns an ST_Geometry value.
All ST_Geometry types.
Teradata Database provides this method because it is in the SQL/MM Spatial standard, where it is defined to implement transform functionality that allows importing the ST_Geometry type to the server.
For best performance, use a constructor method instead of ST_WKBToSQL to construct an instance of ST_Geometry.
USING (a INTEGER,
b BLOB(60000))
INSERT INTO sample_shapes VALUES (:a,
new ST_Geometry('POINT(1 2)').ST_WKBToSQL(:b));