Try something like this
SELECT DISTINCT ON (boundary.id) boundary.*
FROM boundary, location
WHERE ST_Intersects (boundary.geom, location.geom)
[paul ramsey made an improvement, but forgot the I in ID]
Martin F
- 9k
- 38
- 60