Use index with x = ANY(array_column) expression

Hi all, Is there a way to speed up ANY-based array element search with some kind of index? I mean this: WHERE = ANY() Or is GIN index the only option with the @> operator? WHERE @> ARRAY[] Thank you, Otto

Re: [GENERAL] Full text search with plain input

Thank you David, I will do something similar. 2018-05-05 3:12 GMT+02:00 David G. Johnston : > On Friday, May 4, 2018, Havasvölgyi Ottó > wrote: > >> >> Now I am thinking about splitting the input text myself to terms, then >> searching and ranking the documents for

Re: [GENERAL] Full text search with plain input

8-05-05 2:06 GMT+02:00 David G. Johnston : > On Friday, May 4, 2018, Havasvölgyi Ottó > wrote: > >> so that it matches (with less rank) even if one of its words match ? >> > > That seems to be what "ts_rank" provides. > > David J. > >

[GENERAL] Full text search with plain input

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