I tried all that and you can see it on this thread, there are some limitations on indexs on xpath work
On Tue, Mar 16, 2010 at 2:21 PM, Richard Huxton <dev@xxxxxxxxxxxx> wrote:
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
Would you not be better off with an XML data-type if that's how you want to treat the data?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 ?
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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
