PG Doc comments form <noreply(at)postgresql(dot)org> writes:
> SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat');
> This is giving false, even I tried for various other examples for plural to
> singular matching but it fails.
The case works for me, but I have
=# show default_text_search_config;
default_text_search_config
----------------------------
pg_catalog.english
(1 row)
I'm betting your default is set to some other language in which
stripping trailing "s" wouldn't make sense.
regards, tom lane