From: Tom Lane <tgl@sss.pgh.pa.us>
To: imanpreetsinghbindra@gmail.com
cc: pgsql-docs@lists.postgresql.org
Subject: Re: vectorization is not helping with plural to singular matching
In-reply-to: <164120567509.21660.961997564465368296@wrigleys.postgresql.org>
References: <164120567509.21660.961997564465368296@wrigleys.postgresql.org>
Comments: In-reply-to PG Doc comments form <noreply@postgresql.org>
	message dated "Mon, 03 Jan 2022 10:27:55 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3547414.1641223616.1@sss.pgh.pa.us>
Date: Mon, 03 Jan 2022 10:26:56 -0500
Message-ID: <3547415.1641223616@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3547415.1641223616%40sss.pgh.pa.us>
Precedence: bulk

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