Skip to main content
1 of 2
Arash m
  • 55
  • 1
  • 2
  • 7

How to select from geometry column in postgresql?

I've got a table which it has a geometry column filed by some point (ex. "POINT Z (116.309627 39.991285 148)"). now I want to select point's id from the table. I wrote follow sql Code but I force an error (ERROR: Operation on two GEOMETRIES with different SRIDs SQL state: XX000).

select id from database where (point_lat_lon = 'POINT Z (116.309627 39.991285 148)');

Arash m
  • 55
  • 1
  • 2
  • 7