Postgis query - function st_x(geography) does not exist

I have the following query:

select 
 ST_X(location) AS x1, 
 ST_Y(location) as y1,
  location as loc
 from properties 
 where id = 1;

select 
 ST_X(location) AS x1, 
 ST_Y(location) as y1,
  location as loc
 from properties 
 where id = 1;

select 
 ST_X(location) AS x1, 
 ST_Y(location) as y1,
  location as loc
 from properties 
 where id = 1;

select 
 ST_X(location) AS x1, 
 ST_Y(location) as y1,
  location as loc
 from properties 
 where id = 1;

However result shows:

Failed to run sql query: function st_x(geography) does not exist

Failed to run sql query: function st_x(geography) does not exist

Failed to run sql query: function st_x(geography) does not exist

Failed to run sql query: function st_x(geography) does not exist

I have tripled check that postgis extension is enabled, what else is a must for this query to work? Or maybe I have an error in my query? Regards.

Postgis query - function st_x(geography) does not exist

Similar Threads

Similar Threads

Similar Threads