postgis function in graphql/hasura

user_17284403 0
Viewed 101

I'm new to graphql/hasura. I want to run the following raw sql in hasura through mutation:

update features
set feature = st_translate(feature, 150,30);

This sql translates the whole feature column in table features. It seems this is not achievable through mutation? Mainly because st_translate is a function which cannot be used in the hasura query _set:feature{}?

hasura graphql postgis postgresql
1 Answers

solved by using run_sql to post raw sql.

user_172844030
Related