I have a text column in a table. We store XML in this column. Now I want to
search for tags and values

Example data:

<bank>
  <name>Citi Bank</name>
  .....
  .....
/<bank>

I would like to run the following query:

select * from xxxx where to_tsvector('english',xml_column) @@
to_tsquery('<name>Citi
Bank</name>')

This works fine but it also works for any tag as long as the name 'Citi
Bank' is present.

How do I have to setup my search in order for this to work so I get an exact
match for the tag and value ?

Reply via email to