pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedvectorization is not helping with plural to singular matching
2+ messages / 2 participants
[nested] [flat]
* vectorization is not helping with plural to singular matching
@ 2022-01-03 10:27 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2022-01-03 10:27 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: imanpreetsinghbindra@gmail.com
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: vectorization is not helping with plural to singular matching
@ 2022-01-03 15:26 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2022-01-03 15:26 UTC (permalink / raw)
To: imanpreetsinghbindra@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-01-03 15:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-01-03 10:27 vectorization is not helping with plural to singular matching PG Doc comments form <noreply@postgresql.org>
2022-01-03 15:26 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox