Indexing an XMLTABLE query?

2020-10-08 Thread Kanninen Anssi EXT 
Hi there!

Is there any way to use indexes with XMLTABLE-query to query XML type data?
I've only managed to use text[] indexes with plain xpath queries. Is there any 
similar workaround for XMLTABLE type queries?

Cheers!

  *   Anssi Kanninen, Helsinki, Finland

Re: Indexing an XMLTABLE query?

2020-10-08 Thread Pavel Stehule 
Hi

pá 9. 10. 2020 v 7:40 odesílatel Kanninen Anssi EXT <
[email protected]> napsal:

> Hi there!
>
>
>
> Is there any way to use indexes with XMLTABLE-query to query XML type data?
>
> I've only managed to use text[] indexes with plain xpath queries. Is there
> any similar workaround for XMLTABLE type queries?
>

XMLTABLE returning set of records, and for these functions there are not
functional indexes

Regards

Pavel



>
> Cheers!
>
>- Anssi Kanninen, Helsinki, Finland
>
>