Richard I tried all that and you can see it on this thread, there are some limitations on indexs on xpath work
http://archives.postgresql.org/pgsql-general/2010-03/msg00270.php <http://archives.postgresql.org/pgsql-general/2010-03/msg00270.php> On Tue, Mar 16, 2010 at 2:21 PM, Richard Huxton <d...@archonet.com> 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 >> > > 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
