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