Re: Text search prefix matching and stop words

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