ST_GeomFromBinary method

ST_Geometry::ST_GeomFromBinary(binary-string[, srid])

Name	Type	Description
binary-string	LONG BINARY	A string containing the binary representation of a geometry. The input can be in any supported binary format, including WKB or EWKB.
srid	INT	The SRID of the result. If not specified and the input string does not provide a SRID, the default is 0.

ST_Geometry Returns a geometry value of the appropriate type based on the source string.
The spatial reference system identifier of the result is the given by parameter srid.

Parses a string containing one of the supported formats and creates a geometry value of the appropriate type. This method is used by the server when evaluating a cast from a binary string to a geometry type.

Some input formats contain a SRID definition. If provided, the srid parameter must match any value taken from the input string.

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension

The following example returns the result Point (10 20).

SELECT ST_Geometry::ST_GeomFromBinary( 0x010100000000000000000024400000000000003440 )

ST_GeomFromBinary method

Syntax

Parameters

Returns

Remarks

See also

Standards and compatibility

Example