I have some lat/long coordinates eg:
(64.123456789123456, -110.12341234123412)
I store them in the table using a query that looks like this:
INSERT INTO myTable (name, geo) VALUES ('test', ST_GeogFromText('SRID=4326;POINT(-110.12341234123412 64.123456789123456)') );
but when I try to retrieve the lat-long back from the table, they seem to be rounded off, in this case, I get
lat: 64.1234567891234
and
long:-110.123412341234
select ST_X(geo::geometry) as long, ST_Y(geo::geometry) as lat from myTable;
I am probably not using the right data types resulting in loss of values, but haven't been able to figure out.
I am new to PostgreSQL.
How do I not lose the coordinate precision?