Обсуждение: BUG #6395: Invalid XPath expression

The following bug has been logged on the website:

Bug reference:      6395
Logged by:          Franco Ricci
Email address:      franco.ricci@phys.uniroma1.it
PostgreSQL version: 9.1.2
Operating system:   FreeBSD 9
Description:=20=20=20=20=20=20=20=20

Query at bottom returns:
"ERROR:  invalid XPath expression
DETAIL:  Invalid expression

********** Error **********

ERROR: invalid XPath expression
SQL state: XX000
Detail: Invalid expression"

The same query on PostgreSQL 9.x works fine!


------
SELECT
xpath('/llrp:RO_ACCESS_REPORT/llrp:TagReportData/llrp:*[contains(name(),\"E=
PC\")]/llrp:EPC/text()',


'<llrp:RO_ACCESS_REPORT
xmlns:llrp=3D"http://www.llrp.org/ltk/schema/core/encoding/xml/1.0"
Version=3D"1" MessageID=3D"8">
  <llrp:TagReportData>
    <llrp:EPC_96>
      <llrp:EPC>04954524D0004980B0DF0001</llrp:EPC>
    </llrp:EPC_96>
    <llrp:ROSpecID>
      <llrp:ROSpecID>100</llrp:ROSpecID>
    </llrp:ROSpecID>
  </llrp:TagReportData>
</llrp:RO_ACCESS_REPORT>'::xml

, ARRAY[ARRAY['llrp',
'http://www.llrp.org/ltk/schema/core/encoding/xml/1.0']])
----------

* franco ricci:

> The same query on PostgreSQL 9.x works fine!

I think you mean 9.0.

> xpath('/llrp:RO_ACCESS_REPORT/llrp:TagReportData/llrp:*[contains(name(),\=
"EPC\")]/llrp:EPC/text()',

Does it work if you drop the '\'?

PostgreSQL 9.1 defaults to standard_conforming_strings=3Don.  See the
release notes for details.

--=20
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstra=DFe 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

On 12-1-2012 4:58 PM, Florian Weimer wrote:
> * franco ricci:
>
>> The same query on PostgreSQL 9.x works fine!
> I think you mean 9.0.
Yes, I mean 9.0.5
>
>> xpath('/llrp:RO_ACCESS_REPORT/llrp:TagReportData/llrp:*[contains(name(),\"EPC\")]/llrp:EPC/text()',
> Does it work if you drop the '\'?
Thanks a lot.
Without '\' it works!!
>
> PostgreSQL 9.1 defaults to standard_conforming_strings=on.  See the
> release notes for details.
>
Regards
Franco Ricci

--
Franco Ricci
LabIT
Sviluppo Servizi Informatici

Dipartimento di Fisica
Università di Roma "La Sapienza"
Piazzale Aldo Moro, 5
00185
Roma
Italy

tel +390649913449
fax +39064463158