vectorization is not helping with plural to singular matching
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/textsearch-intro.html
Description:
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.
e.g. select to_tsvector('buildings') @@ plainto_tsquery('building')
This simple match is also coming as false, means vectorization is not
helping with plural to singular matching.
version used:
PostgreSQL 13.4 on aarch64-unknown-linux-gnu, compiled by gcc (GCC) 7.3.1
20180712 (Red Hat 7.3.1-6), 64-bit
PG Doc comments form <noreply@postgresql.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