multi-word expression full-text searching

Поиск
Список
Период
Сортировка
От Fco. Mario Barcala" Rodríguez
Тема multi-word expression full-text searching
Дата
Msg-id 1214841002.5802.18.camel@tambre
обсуждение исходный текст
Ответы Re: multi-word expression full-text searching  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-general
Hello all:

I'm testing all full-text searching possibilities of PostgreSQL and...

Is it possible to search for a multi-word expression?

I can search one or more words:

SELECT id FROM document WHERE to_tsvector('english',text) @@
to_tsquery('english','despite');

SELECT id FROM document WHERE to_tsvector('english',text) @@
to_tsquery('english','despite & subject');

But it seems not be possible to do a query like:

SELECT id FROM document WHERE to_tsvector('english',text) @@
to_tsquery('english','despite this');

to search the documents in which occur the expression "despite this".
This last query gives the following error:

ERROR:  syntax error in tsquery: "despite this"

Is it really impossible to searh a multi-word expression?

Thanks in advance,

  Mario Barcala


В списке pgsql-general по дате отправления:

Предыдущее
От: "A B"
Дата:
Сообщение: Re: "The tuple structure of a not-yet-assigned record is indeterminate."
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Advice Wanted on Selecting Multi-row Data Requests in 10-Row Blocks