Thread: XML indexing

XML indexing

From
antony.carvalho@lightbase.com.br
Date:
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