ST_LinestringFromWKB — Makes a geometry from WKB with the given SRID.
geometry ST_LinestringFromWKB(
bytea WKB)
;
geometry ST_LinestringFromWKB(
bytea WKB, integer srid)
;
The ST_LinestringFromWKB
function, takes a well-known binary
representation of geometry and a Spatial Reference System ID (SRID
)
and creates an instance of the appropriate geometry type - in this case, a
LINESTRING
geometry. This function plays the role of the Geometry
Factory in SQL.
If an SRID is not specified, it defaults to -1. NULL
is
returned if the input bytea
does not represent a
LINESTRING
geometry. This an alias for ST_LineFromWKB.
OGC SPEC 3.2.6.2 - optional SRID is from the conformance suite. |
If you know all your geometries are |
This method implements the OpenGIS Simple Features Implementation Specification for SQL. OGC SPEC 3.2.6.2
This method implements the SQL/MM specification: SQL-MM 3: 7.2.9
SELECT ST_LineStringFromWKB( ST_AsBinary(ST_GeomFromText('LINESTRING(1 2, 3 4)')) ) AS aline, ST_LinestringFromWKB( ST_AsBinary(ST_GeomFromText('POINT(1 2)')) ) IS NULL AS null_return; aline | null_return ------------------------------------------------ 010200000002000000000000000000F ... | t