wis
> *Cc: *"pgsql-gene...@postgresql.org"
> *Subject: *Re: Using XMLNAMESPACES with XMLEMENT
>
>
>
> Hi
>
>
>
> pá 24. 9. 2021 v 23:44 odesílatel Garfield Lewis <
> garfield.le...@lzlabs.com> napsal:
>
> Hi All,
>
>
>
> I am att
Thx @Pavel Stehule<mailto:pavel.steh...@gmail.com>, I’ll see if I can figure
this out… ☺
Regards,
Garfield
From: Pavel Stehule
Date: Friday, September 24, 2021 at 11:33 PM
To: Garfield Lewis
Cc: "pgsql-gene...@postgresql.org"
Subject: Re: Using XMLNAMESPACES with XMLEME
Hi
pá 24. 9. 2021 v 23:44 odesílatel Garfield Lewis
napsal:
> 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 "f
t 6:52 PM
> To: Garfield Lewis
> Cc: "pgsql-gene...@postgresql.org"
> Subject: Re: Using XMLNAMESPACES with XMLEMENT
>
>
>
>
> On Sep 24, 2021, at 3:44 PM, Garfield Lewis wrote:
>
> Hi All,
>
> I am attempting to port the follo
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
Date: Friday, September 24, 2021 at 6:52 PM
To: Garfield Lewis
Cc: "pgsql-gene...@postgresql.org"
Subject: Re: Using XMLNAMESPACES with XMLEMENT
> On Sep 24, 2021, at 3:44 PM, Garfield Lewis 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"),
>
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.
