I'm trying to query all the objects within 100m and I want the result to be in GeoJSON not a list of GeoJSON. I'm using PostgreSQL 9.1, PostGIS 2.0. Tried this query:
SELECT ST_AsGeoJSON(geocolumn) FROM geotable WHERE ST_DWithin(geocolumn, 'POINT(1000 1000)', 100.0);
but the result is a list of GeoJSON.
Is there a way to convert the result of my query to a single GeoJSON output?