|
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@xxxxxxxxxxx To: polobo@xxxxxxxxx Subject: RE: 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@xxxxxxxxx > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general |
