Trigger spatial join on isert and update

by GIOVA.A88   Last Updated October 10, 2019 15:22 PM

i've a problem with a trigger in postgres. i can do the query but i don't know to development a trigger. the example query is:

select schemaA.table1.value
from schemaB.table2

where geomA is a point geometry and geomB is a polygon geometry.

Can i help me please?


Tags : postgis

Answers 1

Try this:

select schemaA.table1.value
from schemaA.table1, schemaB.table2
where st_contains(schemaB.table2.geom,schemaA.table1.geom)
Marco Reliquias
Marco Reliquias
October 10, 2019 14:49 PM

Related Questions

Updated February 20, 2017 03:22 AM

Updated October 04, 2018 22:22 PM

Updated October 05, 2018 22:22 PM

Updated December 11, 2018 13:22 PM

Updated February 01, 2019 21:22 PM