[regexonimoo]

Hi guys,
I store xml objects in a postgres table: table(xml_id, xml_src)
example:

<xmlobject>
<name>james</name>
<category>3</category>
<marks>ACTION,HORROR,THRILLER</marks>
<search_attributes>
<searchattribute>
  <type>DOUBLE</type>
  <name>Double</name>
</searchattribute>
<searchattribute>
  <type>SINGLE</type>
  <name>single</name>
</searchattribute>
</search_attributes>
</xmlobject>

Now I want to do a full table search. I want to search after category, marks and the search attributes.

example:
select all objects where category is 3, marks contains HORROR and ACTION, and the searchattribute contains DOUBLE.

Performance is very important. Maybe you can give me hints how I have to index. I use xpaths...

I would be very happy, if there is someone, who can help me...

thanks and bye

[regexonimoo]

: (
nobody can give me an advice?

[shammat]

Just create the indexes on the expressions you use in your where clause.