clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36238 in the last week).

WITH mydata AS ( SELECT '<?xml version="1.0" encoding="UTF-8"?><attachments><entry file="cewe_gw.jpg" name="cewe_gw.jpg"/><entry file="wp1827515.png" name="wp1827515.png"/></attachments>'::xml ) SELECT xpath('//entry/@file',xml) FROM mydata
xpath
{cewe_gw.jpg,wp1827515.png}
 hidden batch(es)


WITH mydata AS ( SELECT '<?xml version="1.0" encoding="UTF-8"?><attachments><entry file="cewe_gw.jpg" name="cewe_gw.jpg"/><entry file="wp1827515.png" name="wp1827515.png"/></attachments>'::xml ) SELECT unnest(xpath('//entry/@file',xml)) FROM mydata
unnest
cewe_gw.jpg
wp1827515.png
 hidden batch(es)