Re: to_tsvector() chopping off trailing 's' characters

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Re: to_tsvector() chopping off trailing 's' characters
Дата
Msg-id CAOC+FBWByhjrZTR7st1nfzqQ7g+yvjtB29oScpFAuMy398eJaQ@mail.gmail.com
обсуждение исходный текст
Ответ на to_tsvector() chopping off trailing 's' characters  (Wells Oliver <wells.oliver@gmail.com>)
Ответы Re: to_tsvector() chopping off trailing 's' characters
Список pgsql-admin
Дерево обсуждения
Sorry for the follow up, meant to add I tried this:

select 'Thames', to_tsvector('simple', 'fat cats ate rats');

And it throws: ERROR:  invalid input syntax for type oid: "simple"

Even though doing \dF in psql shows that 'simple' is available in the list of text search configurations.


On Fri, Nov 1, 2019 at 11:28 AM Wells Oliver <wells.oliver@gmail.com> wrote:
I don't understand this behavior in 12 (worked in 9.6), but:

select 'Thames', to_tsvector('John Thames');

Gives you a vector of: 'john':1 'thame':2

And searching for the full 'Thames' returns no results.

What's happening here?

--


--

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

Предыдущее
От: Wells Oliver
Дата:
Сообщение: to_tsvector() chopping off trailing 's' characters
Следующее
От: Tom Lane
Дата:
Сообщение: Re: to_tsvector() chopping off trailing 's' characters