Skip to content

Latest commit

 

History

History
41 lines (31 loc) · 1.1 KB

stgeogfromwkb.md

File metadata and controls

41 lines (31 loc) · 1.1 KB
description
This section contains reference documentation for the ST_GeogFromWKB function.

ST_GeogFromWKB

Returns a geography type object from WKB representation.

Signature

ST_GeogFromWKB(wkb)

Usage Examples

select STPOINT(-122, 37) AS point,
       ST_GeogFromWKB(
         ST_AsBinary(STPOINT(-122, 37))
       ) AS value
from ignoreMe 
point value
00c05e8000000000004042800000000000 80c05e8000000000004042800000000000
select STPOINT(-122, 37, 1) AS point,
       ST_GeogFromWKB(
         ST_AsBinary(STPOINT(-122, 37, 1))
       ) AS value
from ignoreMe 
point value
80c05e8000000000004042800000000000 80c05e8000000000004042800000000000

{% hint style="info" %} You can create geometry objects in the WKB format using the ST_AsBinary function. {% endhint %}