[postgis-users] performace question

Martin Landa landa.martin at gmail.com
Wed Apr 1 09:50:01 PDT 2009


Hi,

2009/4/1  <geniaux at avignon.inra.fr>:
> 3) use "SELECT count(obce.gid) FROM obce,cr WHERE  obce.the_geom && cr.the_geom
> and ST_Touches(obce.the_geom,cr.the_geom);"

it will not help, all polygons from 'obce' are inside of 'cr' - I just
want to select those polygons from 'obce' (multipolygon) which share
with boundary of 'cr' (linestring) at least one point.

M.

-- 
Martin Landa <landa.martin gmail.com> * http://gama.fsv.cvut.cz/~landa



More information about the postgis-users mailing list