Re: [PATCH] Phrase search ported to 9.6

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: [PATCH] Phrase search ported to 9.6
Дата
Msg-id 56FE762F.4080607@sigaev.ru
обсуждение исходный текст
Ответ на Re: [PATCH] Phrase search ported to 9.6  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: [PATCH] Phrase search ported to 9.6  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-hackers
> there was a character that was very similar to dots I would suggest
> that.  The closest is * I think, so what do you think of "***"?

And join opertator for tsqueries is the same :
select 'fat'::tsquery *** 'cat'; ?

Single '*' ?  That's close to regex, any number of tokens. And it saves rules 
about duplicating character.

select 'fat'::tsquery ** 'cat';
select 'fat * cat'::tsquery;
select 'fat * [3] cat'::tsqyery; -- for non-default distance.


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 



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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: WIP: Access method extendability
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: pg_xlogdump fails to handle WAL file with multi-page XLP_FIRST_IS_CONTRECORD data