Yeah, that works and is much faster than ST_Distance(). For what it's worth, if I:
ALTER TABLE store ADD COLUMN buf Geography(Polygon); UPDATE store SET buf = ST_Buffer(geog, 400000); SELECT COUNT(*) FROM person AS p, store AS s WHERE ST_Intersects(s.buf, p.geog); it works and it's fast... as fast as or slightly faster than ST_DWithin(). If general consensus is that it shouldn't be doing that, I will file a bug. I just wanted to be sure I'm not hitting a known and documented issue. Thanks, Dan On Wed, Mar 26, 2014 at 3:16 PM, George Silva <[email protected]> wrote: > Have you tried using ST_DWithin? _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
