Re: SQL State XX000 : XML namespace issue
| От | Panneerselvam Posangu |
|---|---|
| Тема | Re: SQL State XX000 : XML namespace issue |
| Дата | |
| Msg-id | COL126-W3157A76B4C8190C9657E3EDFB30@phx.gbl обсуждение исходный текст |
| Ответ на | SQL State XX000 : XML namespace issue (Panneerselvam Posangu <panneerpps@hotmail.com>) |
| Ответы |
Re: SQL State XX000 : XML namespace issue
|
| Список | pgsql-general |
to be specific, this is the SQL.
From: panneerpps@hotmail.com
To: polobo@yahoo.com
Subject: RE: [GENERAL] SQL State XX000 : XML namespace issue
Date: Fri, 10 Jan 2014 16:24:21 +0530
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@hotmail.com
To: polobo@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: polobo@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
> From: polobo@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
В списке pgsql-general по дате отправления: