Re: BUG #15753: FullText search cannot find bird, rat from birds, rats

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #15753: FullText search cannot find bird, rat from birds, rats
Дата
Msg-id CAMkU=1yKHTLHhhbJ+qy3NVYzVb7aOMYZsg5=xhXTT4eELLa9Kg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #15753: FullText search cannot find bird, rat from birds, rats  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
On Sun, Apr 14, 2019 at 12:30 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15753
Logged by:          Ozan Gerdaneri
Email address:      ozan.gerdaneri@gmail.com
PostgreSQL version: 11.2
Operating system:   win 10
Description:       

Hi,
I have a column that contains words like cats, birds, rats ..  When I make
query with cat, it finds the column but  query doe snot return any result
with rat and bird? Do I need to make some configurations to enable this
feature?


You might need to change your configuration, but since you haven't told us what your configuration is, we don't know if you need to change it.

Meanwhile, the default configuration works for me.

create table foobar2 (x text);
insert into foobar2 values('cats, birds, rats');
select * from foobar2 where to_tsvector(x) @@ to_tsquery('bird');
         x
-------------------
 cats, birds, rats
 
Cheers,

Jeff

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15753: FullText search cannot find bird, rat from birds, rats
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15754: The CentOS RPM for PostgreSQL 11 disappeared and now throws a 404 error