[postgis-users] Quick note on how NOT to use ST_Intersects()

[Dylan Beaudette]

Hi,

Thinking (falsely) that I would cleverly locate where two sets of polygons did 
not overlap, I gave something like this a try:

CREATE TABLE big_mistake as
SELECT a.something, b.something
FROM
a
JOIN
b
ON
ST_Instersects(a,b) = FALSE;

... postgresql then proceeded to fill my harddrive with garbage!

Note the self: don't try seemingly clever tricks without first *thinking* 
about them.

Dylan


-- 
Dylan Beaudette
Soil Resource Laboratory
http://casoilresource.lawr.ucdavis.edu/
University of California at Davis
530.754.7341