New answers tagged spatial
The simplest solution without PostGIS would be to store lat/long as two number columns. numeric for exact precision. double precision or even just real if you don't need the precision. I see no reason why the data type point shouldn't work as well. Per documentation: Points are the fundamental two-dimensional building block for geometric types. Values ...
With GeomFromText or any other *FromText function you can specify the SRID. I don't think you can do it otherwise. PointFromText('POINT(lat lng)', 4326)
Top 50 recent answers are included