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

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

Example

SELECT ST_Distance('LINESTRING(-122.33 47.606, 0.0 51.5)'::geometry, 'POINT(-21.96 64.15)'::geometry); 

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

Example

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); 
Source Link
CaptDragon
  • 13.5k
  • 7
  • 57
  • 96

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

Example