[postgis-users] Check geometry for true intersection using ST_Relate

Nicolas Ribot nicolas.ribot at gmail.com
Mon Jul 19 01:49:07 PDT 2010

Glup. :)
The manual is giving a simpler, more accurate (index usage) answer:

SELECT l.* , b.name As poly_name
FROM polys As b
	INNER JOIN compounds As l
	ON (p.the_geom && b.the_geom
	AND ST_Relate(l.the_geom, b.the_geom,'T********'));



More information about the postgis-users mailing list