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.

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Ivan Voras
Дата:
Сообщение: Re: Consistent file-level backup of pg data directory
Следующее
От: M Tarkeshwar Rao
Дата:
Сообщение: Re: Consistent file-level backup of pg data directory