Re: Text search prefix matching and stop words - Mailing list pgsql-bugs

From Artur Zakirov
Subject Re: Text search prefix matching and stop words
Date
Msg-id CAKNkYnw63mGssUzeKb=FVPXwOXmV_Qrk0fd6pozHvFuDQD1Pfw@mail.gmail.com
Whole thread Raw
In response to Re: Text search prefix matching and stop words  (Pavel Borisov <pashkin.elfe@gmail.com>)
List pgsql-bugs
On Fri, Oct 8, 2021 at 10:31 PM Pavel Borisov <pashkin.elfe@gmail.com> wrote:
> If you want to process successive characters typing, you can use casting to tsvector type until input is not
finished
>
> 'over:*'::tsquery;

Also it is possible to use a custom configuration without stop words
if you want normalization:

postgres=# select to_tsquery('english_wo_stop', 'over:*') &&
to_tsquery('english', 'foo');
     ?column?
------------------
 'over':* & 'foo'

-- 
Artur



pgsql-bugs by date:

Previous
From: Emil Iggland
Date:
Subject: Re: BUG #17141: SELECT LIMIT WITH TIES FOR UPDATE SKIP LOCKED returns wrong number of rows
Next
From: PG Bug reporting form
Date:
Subject: BUG #17220: ALTER INDEX ALTER COLUMN SET (..) with an optionless opclass makes index and table unusable