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 ?