Re: Text search

On 16/03/10 10:29, Chris Roffler wrote:
> I have a text column in a table. We store XML in this column. Now I want to
> search for tags and values

> 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 ?

Would you not be better off with an XML data-type if that's how you want
to treat the data?
http://www.postgresql.org/docs/8.4/static/datatype-xml.html
http://www.postgresql.org/docs/8.4/static/functions-xml.html
http://www.postgresql.org/docs/8.4/static/xml2.html

--
Richard Huxton
Archonet Ltd