WITH
SELECT ST_Dump(ST_CollectionExtract(geom),2) AS geom
FROM my_geo_collection AS c

SELECT c.geom, t.geom FROM
c, my_geometry AS t

WHERE c.geom = t.geom