SELECT DISTINCT ON (t1.name) t1.gid,t1.name,t1.the_geom,t2.gid,t2.name,t2.the_geom
FROM all_poi AS t1
JOIN all_poi AS t2 ON ST_Dwithin(t1.the_geom,t2.the_geom,(0.005/111.111))
WHERE t1.gid != t2.gid and t1.name=t2.name and t1.name like'%%'
ORDER BY t1.name, t1.gid,t2.gid,t2.name,t2.the_geom;