On 19/07/10 05:41, Irooniam wrote:
> However, when I check which index it's using, it's not using the xpath
> index:
> explain select * from test where ((xpath('//names/name[. ="bob"]/text()',
> data))[1]::text) = 'bob';
>QUERY
> PLAN
> -
Hello,
I've searched the mailing list and I tried using defining a xpath index per
the post, but my query is still not using it.
Essentially, I'm storing a fragment of xml and I want to create xpath
indexes on them.
The two rows I'm going to insert look like this (alex & bob are the only
names r
