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.htmlhttp://www.postgresql.org/docs/8.4/static/functions-xml.htmlhttp://www.postgresql.org/docs/8.4/static/xml2.html -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:http://www.postgresql.org/mailpref/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
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:
Соглашаюсь с условиями обработки персональных данных
