to be specific, this is the SQL.
SELECT to_number((SELECT
array_to_string((SELECT xpath('/attributes/duration/text()',(SELECT XMLPARSE
(CONTENT
'<attributes><duration>2</duration><maxlicenses>2</maxlicenses><paymentrequired>true</paymentrequired><autopurchase>true</autopurchase><graceperiod>0</graceperiod></attributes>')),ARRAY[ARRAY['',
'']])
),'','')),'999999999') > 30
Thank you
From: panneer...@hotmail.com
To: pol...@yahoo.com
Subject: RE: [GENERAL] SQL State XX000 : XML namespace issue
Date: Fri, 10 Jan 2014 16:24:21 +0530
Hi,
This is the query that we use.
SELECT to_number((SELECT
array_to_string((SELECT xpath('/attributes/duration/text()',(SELECT XMLPARSE
(CONTENT p.ATTRIBUTES)),ARRAY[ARRAY['', '']])
),'','')),'999999999') > 30 from jcp_promotions_b p
ATTRIBUTES is of type XML
Thank you
Panneer
> Date: Thu, 9 Jan 2014 21:44:11 -0800
> From: pol...@yahoo.com
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] SQL State XX000 : XML namespace issue
>
> Panneerselvam Posangu wrote
> > Hi,
> > When we run a SQL statement in Postgres 9.2 we get an error.
> > Error : Could not register XML namespace with name "" and URI "" SQL State
> > XX000
> > In the SQL state we use xpath function. Any reason why this is happening..
> > Thanks,Panneer
>
> No. Try providing more detail. Especially the actual statement you are
> running. And, better, try to supply a minimal and self-contained query that
> exhibits the same behavior.
>
> David J.
>
>
>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/SQL-State-XX000-XML-namespace-issue-tp5786103p5786222.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
