gistfile1.txt

SELECT imagettes FROM (
  SELECT DISTINCT                                                                                                                                                                 
          id as metadataid,                                                                                  
          unnest(xpath('//gmd:graphicOverview/gmd:MD_BrowseGraphic/gmd:fileName/gco:CharacterString/text()',
                data::xml,
                ARRAY[
                  ARRAY['gmd', 'http://www.isotc211.org/2005/gmd'],
                  ARRAY['gco', 'http://www.isotc211.org/2005/gco']
                ]))::text AS imagettes
  FROM
   geonetwork.metadata
  WHERE isharvested = 'n'
) AS foo WHERE imagettes ilike '%resources.get%';