I have following request:
SELECT XMLAGG(data) FROM (SELECT XMLELEMENT(name item, XMLFOREST( title, body as description, date_created as date, 'http://example.com/news'||id as link )) AS data FROM NEWS) AS smthng;
The issue is that body is actually XML itself, so the question is -
How can I escape XML field (changing
> etc.) in this query?