> On Sep 24, 2021, at 4:54 PM, Garfield Lewis <garfield.le...@lzlabs.com> wrote:
>
>
> I’m using PG v12.6 and no I haven’t tried the path function. Do you have an
> example?
>
> --
> Regards,
> Garfield A. Lewis
>
> From: Rob Sargent <robjsarg...@gmail.com>
> Date: Friday, September 24, 2021 at 6:52 PM
> To: Garfield Lewis <garfield.le...@lzlabs.com>
> Cc: "pgsql-gene...@postgresql.org" <pgsql-gene...@postgresql.org>
> Subject: Re: Using XMLNAMESPACES with XMLEMENT
>
>
>
>
> 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
https://www.postgresql.org/docs/12/functions-xml.html#FUNCTIONS-XML-PROCESSING
