SELECT ST_INTERSECTION(geom) FROM t1 WHERE foo = 'bar' and ST_INTERSECTS(geom)

select a.geom as A, b.geom as B from t1 a, t1 b where ST_Intersects
(a.geom,b.geom) AND a.id<b.id And a.foo='bar';