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
