On Thu, Nov 10, 2016 at 10:54 PM, l...@laurent-hasson.com < l...@laurent-hasson.com> wrote:
> Hello, > > > > I am trying to implement an efficient “like” over a text[]. I see a lot of > people have tried before me and I learnt a lot through the forums. > Have you looked at parray_gin? https://github.com/theirix/parray_gin (Also on PGXN, but I don't know how up-to-date it is there) Or you could create an regular pg_trgm index on the expression: array_to_string("ICD9_DGNS_CD",'<some safe delimiter>') If you can find a safe delimiter to use (one that can't be part of the text[]). The performance of these options will depend on both the nature of your data and the nature of your queries. Cheers, Jeff