ST_AsBinary function [Spatial]

Returns a binary string representing the specified geometry. The output format is WKB as defined by OGC SFS 1.1. This format does not contain Z and M values.

Syntax

ST_AsBinary(geometry-expression)

Returns

Example

The following statement returns the result 0x0101000000000000000000f03f0000000000000040:

SELECT ST_AsBinary(ST_Point(1.0, 2.0, 4326))

The server implicitly invokes the ST_AsBinary function when converting geometries to BINARY. For example, the following statement returns the result 0x0101000000000000000000f03f0000000000000040:

SELECT CAST(ST_Point(1.0, 2.0, 4326) AS BINARY(50))

Discuss this page in DocCommentXchange.