Re: Text search
От
Chris Roffler
Тема
Re: Text search
Дата
Msg-id
3984722a1003160536y751b58afu44fba25753d490db@mail.gmail.com
Ответ на
Re: Text search (Richard Huxton)
Список
Дерево обсуждения
Text search Chris Roffler <croffler@earthlink.net>
Re: Text search Richard Huxton <dev@archonet.com>
Re: Text search Chris Roffler <croffler@earthlink.net>
Re: Text search Richard Huxton <dev@archonet.com>
Re: Text search Richard Huxton <dev@archonet.com>
Re: Text search Chris Roffler <croffler@earthlink.net>
Richard
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@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 valuesWould 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления
