From: | "Denis I(dot) Polukarov" <d(dot)polukarov(at)gpt(dot)ru> |
---|---|
To: | pgsql-ru-general(at)postgresql(dot)org |
Subject: | Вопрос по xpath |
Date: | 2010-06-03 08:10:08 |
Message-ID: | 201006031210.08949.d.polukarov@gpt.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ru-general |
Добрый день...
Возникли проблемы с xpath, в решении которых ни google, ни документация по
postgresql ответов не дали...
Поля без namespace не ищет:
test=# SELECT xpath('//qDate/text()',
$$<?xml version='1.0' encoding='UTF-8'?>
<epp xmlns='urn:ietf:params:xml:ns:epp-1.0'
xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
xsi:schemaLocation='urn:ietf:params:xml:ns:epp-1.0
epp-1.0.xsd'><response><result code='1301'><msg lang='en-US'>Command completed
successfully; ack to dequeue</msg></result><msgQ count='3'
id='114004'><qDate>2010-06-02T12:35:33.0Z</qDate><msg lang='en-US'>Transfer
Requested.</msg></msgQ><resData><domain:trnData
xmlns:domain='urn:ietf:params:xml:ns:domain-1.0'
xsi:schemaLocation='urn:ietf:params:xml:ns:domain-1.0
domain-1.0.xsd'><domain:name>xxx.xx</domain:name><domain:trStatus>pending</domain:trStatus><domain:reID>admin</domain:reID><domain:reDate>2010-06-02T12:35:33.0Z</domain:reDate><domain:acID>xxx-
xx</domain:acID><domain:acDate>2010-06-07T12:35:33.0Z</domain:acDate><domain:exDate>2014-05-11T12:52:07.0Z</domain:exDate></domain:trnData></resData><trID><svTRID>xx-
xxx</svTRID></trID></response></epp>$$);
xpath
-------
{}
(1 row)
test=#
С namespace ищет:
test=# SELECT xpath('//domain:name/text()',
$$<?xml version='1.0' encoding='UTF-8'?>
<epp xmlns='urn:ietf:params:xml:ns:epp-1.0'
xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
xsi:schemaLocation='urn:ietf:params:xml:ns:epp-1.0
epp-1.0.xsd'><response><result code='1301'><msg lang='en-US'>Command completed
successfully; ack to dequeue</msg></result><msgQ count='3'
id='114004'><qDate>2010-06-02T12:35:33.0Z</qDate><msg lang='en-US'>Transfer
Requested.</msg></msgQ><resData><domain:trnData
xmlns:domain='urn:ietf:params:xml:ns:domain-1.0'
xsi:schemaLocation='urn:ietf:params:xml:ns:domain-1.0
domain-1.0.xsd'><domain:name>xxx.xx</domain:name><domain:trStatus>pending</domain:trStatus><domain:reID>admin</domain:reID><domain:reDate>2010-06-02T12:35:33.0Z</domain:reDate><domain:acID>xxx-
xx</domain:acID><domain:acDate>2010-06-07T12:35:33.0Z</domain:acDate><domain:exDate>2014-05-11T12:52:07.0Z</domain:exDate></domain:trnData></resData><trID><svTRID>xx-
xxx</svTRID></trID></response></epp>$$,
array[array['domain','urn:ietf:params:xml:ns:domain-1.0']]);
xpath
-------------
{xxx.xx}
(1 row)
test=#
Почему не ищет поле без namespace?
--
Best regards,
Denis I. Polukarov
From | Date | Subject | |
---|---|---|---|
Next Message | Nikolay Samokhvalov | 2010-06-03 10:21:00 | Re: [pgsql-ru-general] Вопрос по xpath |
Previous Message | Evgeny M. Baldin | 2010-06-03 06:11:39 | К вопросу о публикациях про PostgreSQL |