Nicolas Even <ne...@ztel.org> 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
