Can you share your data with me? I'm interested to profile and see where the bottleneck actually is.
P. On Wed, Apr 1, 2009 at 9:50 AM, Martin Landa <[email protected]> wrote: > Hi, > > 2009/4/1 <[email protected]>: >> 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 > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
