[GENERAL] Full text search with plain input

From: Havasvölgyi Ottó <havasvolgyi(dot)otto(at)gmail(dot)com>
To: Pg - General <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] Full text search with plain input
Date: 2018-05-04 23:54:21
Message-ID: CAOryeA1hRL7HE5i4P262nHE-VS8MZFUfCMFvRaz6QuPSQCpAxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I would like to use PostgreSQL's FTS functionality.
The user would enter a search text, one or more words.
There is a suitable plainto_tsquery() function, but it's to strict. It
only matches if all words match. What is the best practice to make this
kind of search more "forgiving", so that it matches (with less rank) even
if one of its words match ?

Thanks,
Otto

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-05-05 00:06:35 Re: [GENERAL] Full text search with plain input
Previous Message Tom Lane 2018-05-04 22:53:32 Re: Known Bugs on Postgres 9.5