I have points geom in
gid,pt_geom and polygon geom in
gid,pl_geom. Some of the points are inside polygon and some are outside polygon, others are on the polygon boundary.
Is there any way to identify those points on the polygon by using PostGIS functions (
e.g. ST_contains() or ST_Distance())?
Select points.gid from points inner join polygon on st_contains(polygon.the_geom,points.the_geom).