I have 2 tables, one for points and one for polygons. I want to find points falling within theese polygons, so I quered:
select p.id, l.idfrom points p inner join polys l on st_contains(l.geom, p.geom);
and i got invalid join selectivity error. I know that was issue in previous version of postgis but as far as I know it should be fixed in 2.1.3.In my tables I have about 400.000 points and 1.000 polygons - maybe too many?
أكثر...
select p.id, l.idfrom points p inner join polys l on st_contains(l.geom, p.geom);
and i got invalid join selectivity error. I know that was issue in previous version of postgis but as far as I know it should be fixed in 2.1.3.In my tables I have about 400.000 points and 1.000 polygons - maybe too many?
أكثر...