Re: SQL State XX000 : XML namespace issue

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: panneerpps(at)hotmail(dot)com
To: polobo(at)yahoo(dot)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: polobo(at)yahoo(dot)com
> To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general