Postgres Pro
Downloads
Home   >   mailing lists

XML Index again - Mailing list pgsql-general

From Chris Roffler
Subject XML Index again
Date
Msg-id 3984722a1003070202obc32c63q44002a294af2e6f7@mail.gmail.com
Whole thread Raw
Responses Re: XML Index again
List pgsql-general
Tree view
I still have some problems with my xml index

CREATE INDEX xml_index
  ON time_series
  USING btree
  ((
  (xpath('/AttributeList/Attributes/Attribute/Name/text()', external_attributes))[1]::text));

When I run the following query the index is not used :

select id from time_series where  
array_upper(
(xpath('/AttributeList/Attributes/Attribute[Name="Attribute122021"]', external_attributes))
, 1) > 0

Any Idea on how to configure the index ?

Thanks
Chris



pgsql-general by date:

Previous
From: Allan Kamau
Date:
Subject: Avoiding duplicates (or at least marking them as such) in a "cumulative" transaction table.
Next
From: AI Rumman
Date:
Subject: compare two schemas