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

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(dot)oliver(at)gmail(dot)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?
>
> --
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>