I have two geometries:
multi point A
multi polygon B
I want to get all the points of A that overlap with the polygon B
I am not sure how to run this query. I have tried the following query:
SELECT ST_Intersection(A.geom, B.geom) FROM point AS A, poly AS B
But with little succes. How can I change it so that i get only the points of A that are overlap with B?