Re: tsearch2 error msg

Поиск
Список
Период
Сортировка
От AgentM
Тема Re: tsearch2 error msg
Дата
Msg-id 551DED42-1923-452E-8DFE-742CAEC740D0@themactionfaction.com
обсуждение исходный текст
Ответ на Re: tsearch2 error msg  (Oleg Bartunov <oleg@sai.msu.su>)
Ответы Re: tsearch2 error msg  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
On Oct 3, 2006, at 10:49 , Oleg Bartunov wrote:

> On Tue, 3 Oct 2006, Magnus Hagander wrote:
>
>>> BTW, try
>>> # select plainto_tsquery('foo bar');
>>>   plainto_tsquery
>>> -----------------
>>>   'foo' & 'bar'
>>> (1 row)
>>>
>>> It parses plain text and makes tsquery. Function exists only in 8.2
>>> - some later we add docs about changes in tsearch2.
>
> Current docs, covering 8.2 is available from http://www.sai.msu.su/ 
> ~megera/wiki/tsearch2slides

This is great news- previously, I was using various regexes to  
sanitize input into user-accessible search fields. Would it be build  
in some simple query language?

"sam AND spade"
"blue OR yellow"
"(same AND spade) OR (blue AND yellow)"

Obviously, the conjunctions would need to be defined on a per-locale  
basis.

-M


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: timestamptz alias
Следующее
От: Neil Conway
Дата:
Сообщение: Re: PG qsort vs. Solaris