ST_GeogFromWKB

select STPOINT(-122, 37) AS point,
       ST_GeogFromWKB(
         ST_AsBinary(STPOINT(-122, 37))
       ) AS value
from ignoreMe 

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