Re: Avoiding empty queries in tsearch

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Re: Avoiding empty queries in tsearch
Дата
Msg-id Pine.LNX.4.64.0701152208570.18339@sn.sai.msu.ru
обсуждение исходный текст
Ответ на Re: Avoiding empty queries in tsearch  ("Doug Cole" <dougcole@gmail.com>)
Список pgsql-general
Doug,

numnode exists for sure ! It's plainto_tsquery function which
Teodor used in example, appeared in 8.2


Oleg
On Mon, 15 Jan 2007, Doug Cole wrote:

> That sounds perfect, but it doesn't seem to exist on either of the
> postgresql installations I have access to (8.1 on ubuntu and fedora
> core).  Is it new to 8.2?  Is there a similar function under 8.1, or
> at least a decent work-around?  Thanks for the help,
> Doug
>
>
>
> On 1/15/07, Teodor Sigaev <teodor@sigaev.ru> wrote:
>>  contrib_regression=# select numnode( plainto_tsquery('the any') );
>> NOTICE:  query contains only stopword(s) or doesn't contain
> lexeme(s), ignored
>>   numnode
>> ---------
>>         0
>> (1 row)
>>
>> contrib_regression=# select numnode( plainto_tsquery('the table') );
>>   numnode
>> ---------
>>         1
>> (1 row)
>>
>> contrib_regression=# select numnode( plainto_tsquery('long table') );
>>   numnode
>> ---------
>>         3
>> (1 row)
>>
>>
>> --
>> Teodor Sigaev                                   E-mail:  teodor@sigaev.ru
>>                                                     WWW:
> http://www.sigaev.ru/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: Avoiding empty queries in tsearch
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: Reserve a value in a serial type field