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 <[email protected]> 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
> [email protected] <[email protected]>
>


-- 
Wells Oliver
[email protected] <[email protected]>