In my table I have a column "location" that is a POINT. I tried this:
SELECT ST_X(location), ST_Y(location) FROM locations;
But I still get the error message: ERROR: function st_x(point) does not exist
It looks like your column
You have to change
you need to use:
I suppose that locations is a table of points with the geometry named as "geom".
Hope this helps,