vectorization is not helping with plural to singular matching

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: imanpreetsinghbindra(at)gmail(dot)com
Subject: vectorization is not helping with plural to singular matching
Date: 2022-01-03 10:27:55
Message-ID: 164120567509.21660.961997564465368296@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Eric Mutta 2022-01-03 12:40:40 Re: Typo in "27.2.8. Synchronous Replication"
Previous Message Magnus Hagander 2022-01-02 16:08:27 Re: Typo in "27.2.8. Synchronous Replication"