© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
5 replies
paxmx

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;

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


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.
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Postgis Error: function st_makepoint(double precision, double precision) does not exist
SupabaseSSupabase / help-and-questions
5mo ago
type geography does not exist -- suddenly
SupabaseSSupabase / help-and-questions
4y ago
function auth.uid() does not exist
SupabaseSSupabase / help-and-questions
3mo ago
function uuid_generate_v4() does not exist
SupabaseSSupabase / help-and-questions
4y ago