Thank you Tom On 26 July 2018 at 18:44, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Nicolas Even <neven@xxxxxxxx> writes: >> However when I run the same (as far as I understand it) query but with >> the ALL operator, the index is not used: >> explain analyze select name from totoz where name ilike all(array['%tot%']); > > There's only index support for "op ANY (array)", not "op ALL (array)". > > regards, tom lane
