Description

The ST_LineFromWKB 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 a type-specific geometry factory in SQL.

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 - SRID optionnel issu des tests de conformité.

	If you know all your geometries are LINESTRINGs, it is more efficient to use ST_GeomFromWKB directly. This function calls ST_GeomFromWKB and adds validation that the result is a LINESTRING.

Cette méthode implémente la spécification OGC Simple Features Implementation Specification for SQL 1.1. s3.2.6.2

Cette méthode implémente la spécification SQL/MM. SQL-MM 3 : 7.2.9

Exemples

SELECT ST_LineFromWKB(
    ST_AsBinary(ST_GeomFromText('LINESTRING(1 2,3 4)'))
) AS aline,
ST_LineFromWKB(
    ST_AsBinary(ST_GeomFromText('POINT(1 2)'))
) IS NULL AS null_return;

aline                 | null_return
------------------------------------
LINESTRING(1 2,3 4)  | t
                

010200000002000000000000000000F03F000000000000004000000000000008400000000000001040 | t

Figure

Voir aussi

ST_GeomFromWKB, ST_LinestringFromWKB