ST_Intersects and ST_Buffer: No20 Aug 2010
If you find yourself writing a query like this:
... WHERE ST_Intersects(ST_Buffer(g1, r), g2)
Stop. Take a cleansing breath. Do this:
... WHERE ST_DWithin(g1, g2, r)
With the carbon emissions you save doing it the efficient way, you can afford to drive to the ice cream store for a well-deserved reward.