From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | Garfield Lewis <garfield(dot)lewis(at)lzlabs(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Using XMLNAMESPACES with XMLEMENT |
Date: | 2021-09-24 22:52:14 |
Message-ID: | 15F25C40-2929-442D-92D3-4812DDFCEBE1@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Sep 24, 2021, at 3:44 PM, Garfield Lewis <garfield(dot)lewis(at)lzlabs(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Garfield Lewis | 2021-09-24 22:54:54 | Re: Using XMLNAMESPACES with XMLEMENT |
Previous Message | Garfield Lewis | 2021-09-24 21:43:54 | Using XMLNAMESPACES with XMLEMENT |