Postgres Pro
Downloads
Home   >   mailing lists

Thread: Indexing an XMLTABLE query?

Indexing an XMLTABLE query?

From
Kanninen Anssi EXT
Date:

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?

From
Pavel Stehule
Date:
Hi

pá 9. 10. 2020 v 7:40 odesílatel Kanninen Anssi EXT <Anssi.Kanninen@digia.com> 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