Skip to main content
2 of 2
added example and removed dead link
CaptDragon
  • 13.5k
  • 7
  • 57
  • 96

You can cast the geography type to geometry by appending the ::geometry

SELECT ST_Distance('LINESTRING(-122.33 47.606, 0.0 51.5)'::geometry, 'POINT(-21.96 64.15)'::geometry); 
CaptDragon
  • 13.5k
  • 7
  • 57
  • 96