Search Postgresql Archives

Re: Using XMLNAMESPACES with XMLEMENT

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 <robjsargent@xxxxxxxxx>
Date: Friday, September 24, 2021 at 6:52 PM
To: Garfield Lewis <garfield.lewis@xxxxxxxxxx>
Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Subject: Re: Using XMLNAMESPACES with XMLEMENT

 

 



On Sep 24, 2021, at 3:44 PM, Garfield Lewis <garfield.lewis@xxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux