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 <
to <
>
to >
etc.) in this query?