XML indexing - Mailing list pgsql-general

From antony.carvalho@lightbase.com.br
Subject XML indexing
Date
Msg-id p1i5rdg.96988da8265729c933a25dee9f651d09@webmail.lightbase.com.br
Whole thread Raw
List pgsql-general
Hi all,

Im trying to use the xpath funtion to get xml text nodes with efficiency, than i created an index like :
=#create  index doc_idx on testxml using btree (((xpath('/book/id/text()', doc))[1]::text));
But the index is used just when i want xpath('/book/id/text()', doc). I want to get any 
text node from xml doc without having to index that path every time i query.
Do anyone knows how to index like that ? Tx

pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: problem with recreating database with export
Next
From: Adrian Klaver
Date:
Subject: Re: problem with recreating database with export