Text search - Mailing list pgsql-general

From Chris Roffler
Subject Text search
Date
Msg-id 3984722a1003160329i432e0b53t713756f192c078f4@mail.gmail.com
Whole thread Raw
Responses Re: Text search  (Richard Huxton <dev@archonet.com>)
List pgsql-general

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 ?

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: hardware for a server
Next
From: Peter Schmidtke
Date:
Subject: reuse data in existing data directory