Re: Using XMLNAMESPACES with XMLEMENT

Fri, 24 Sep 2021 15:55:13 -0700 

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 <[email protected]>
Date: Friday, September 24, 2021 at 6:52 PM
To: Garfield Lewis <[email protected]>
Cc: "[email protected]" <[email protected]>
Subject: Re: Using XMLNAMESPACES with XMLEMENT




On Sep 24, 2021, at 3:44 PM, Garfield Lewis <[email protected]> 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

Reply via email to