Being totally new with PostGIS, I am trying to UPDATE one of my column on my table.
The column itself is called 'center_point' with type of
UPDATE cities SET center_point = st_setsrid(st_makepoint(-6.28381815,106.804863491948),4326) WHERE id = 1;
Upon verifying the result:
SELECT id, st_asgeojson(shape) AS "geojson", st_asgeojson(center_point) FROM cities WHERE id = 1;
It says that the coordinate is -6.283... , 73.1951...
Where i am expecting it to be -6.283.... , 106.80486
Can anyone help me why the result is different?