How to correctly store coordinates in postgresql and then subtract the distance from the user to a specific object?

Question

PostgreSQL

I found the Postgis extension , added the position

column in the database and overwrote all the coordinates:

UPDATE product_locations SET
  "position" = ST_SetSRID(ST_MakePoint(longitude, latitude),4326);

but when I make a fetch request:

SELECT
  *,
  ST_Distance ( position::geography, ST_GeographyFromText('SRID=4326;POINT(40.5774008 -73.9647576)') )  / 1000 AS distance
FROM
  product_locations 
ORDER BY 
id asc

I get not quite accurate results, see the entry with id 31 (latitude, longitude) are the same as in the request, i.e. for entry 31 , the distance value should be 0 , I don’t
know where to dig

Answer 1

point(longitude, latitude)
but you seem to be the opposite