[GENERAL] Full text search with plain input - Mailing list pgsql-general

From Havasvölgyi Ottó
Subject [GENERAL] Full text search with plain input
Date
Msg-id CAOryeA1hRL7HE5i4P262nHE-VS8MZFUfCMFvRaz6QuPSQCpAxQ@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Full text search with plain input
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Known Bugs on Postgres 9.5
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Full text search with plain input