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@xxxxxxxxx> 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.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx
