ST_LinestringFromWKB
Name
ST_LinestringFromWKB — Creates a
LINESTRING
from a WKB representation, optionally using a given SRID.
Synopsis
geometry
ST_LinestringFromWKB
(
bytea
WKB
)
;
geometry
ST_LinestringFromWKB
(
bytea
WKB
, integer
srid
)
;
Description
The
ST_LinestringFromWKB
function takes a Well-Known Binary
(WKB) representation of a geometry and an optional Spatial Reference System
ID (
SRID
), and creates a
LINESTRING
geometry. It is an alias for
ST_LineFromWKB
.
If an SRID is not specified, it defaults to 0.
NULL
is
returned if the input
bytea
does not represent a
LINESTRING
geometry.
|
|
|
OGC SPEC 3.2.6.2 - optional SRID is from the conformance suite. |
|
|
|
If you know all your geometries are
|
This method implements the
OGC Simple Features
Implementation Specification for SQL 1.1.
s3.2.6.2
This method implements the SQL/MM specification.
SQL-MM 3: 7.2.9
Examples
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 ------------------------------------ LINESTRING(1 2,3 4) | t