Postgres Pro
Downloads
Home   >   mailing lists

to_tsvector() chopping off trailing 's' characters - Mailing list pgsql-admin

From Wells Oliver
Subject to_tsvector() chopping off trailing 's' characters
Date
Msg-id CAOC+FBWAsQy7Gb57xqx8NVo3A5xq_zdrF6FuXXZ_AgmiSfMBeQ@mail.gmail.com
Whole thread Raw
Responses Re: to_tsvector() chopping off trailing 's' characters  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Keith
Date:
Subject: Re: Moving from PG 9-era table inheritance to PG 12 range partioning
Next
From: Wells Oliver
Date:
Subject: Re: to_tsvector() chopping off trailing 's' characters