Handling Complex queries in PostgreSQL fulltext search

Поиск
Список
Период
Сортировка
От Gaini Rajeshwar
Тема Handling Complex queries in PostgreSQL fulltext search
Дата
Msg-id 56b36eb60911010150ybcc227dv6946d23e9bcbeb23@mail.gmail.com
обсуждение исходный текст
Ответы Re: Handling Complex queries in PostgreSQL fulltext search  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-general
Hi All,

Does anyone know how to handle complex queries?

For Example, If i want to search for something like:

(portable battery AND magnetic induction) OR (database management system)

This is a sample query and user can specify any kind of complex query in this way. I can't ask user to specify &, |, ! operators. Instead i can ask to use AND, OR, NOT operators. If nothing is specified by default & operator should be used.

Is there any way to convert/specify user given query in Fulltext Search.

For Example, In Sphinx I can give the same query as

'(portable battery && magnetic induction) | (database management system)'

Here i need not to mention the & operator between portable, battery.

Is there any way we can specify this in PostgreSQL Fulltext search (i.e without bothering about inserting & operator in between)?

Thanks,

Gaini Rajeshwar

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: What order of steps of the postgres when you change information in the table?
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Handling Complex queries in PostgreSQL fulltext search