> On Sep 24, 2021, at 3:44 PM, Garfield Lewis <garfield.le...@lzlabs.com> wrote:
>
>
> Hi All,
>
> I am attempting to port the following statement from DB2z to Postgres:
>
> SELECT e.empno, e.firstnme, e.lastname,
> XMLELEMENT ( NAME "foo:Emp",
> XMLNAMESPACES('http://www.foo.com' AS "foo"),
> XMLATTRIBUTES(e.empno as "serial"),
> e.firstnme,
> e.lastname ) AS "Result"
> FROM EMP e
> WHERE e.edlevel = 12;
>
> The NAMESPACES function is not supported by Postgres in the XMLELEMENT
> function. Is there any way to get this to work? I’ve looked at the WITH
> syntax but it doesn’t look like that will be helpful here.
>
Which Postgres version? Have you tried path function?
> Regards,
> Garfield
