Postgres Pro
Downloads
Home   >   mailing lists

Re: Query with "ILIKE ALL" does not use the index - Mailing list pgsql-performance

From Nicolas Even
Subject Re: Query with "ILIKE ALL" does not use the index
Date
Msg-id CALghGHMYhgaSTaXoXDGNAttDkaFfzcg5WE3k3z0FKNMs2KEnbA@mail.gmail.com
Whole thread Raw
In response to Re: Query with "ILIKE ALL" does not use the index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Thank you Tom

On 26 July 2018 at 18:44, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Nicolas Even <neven@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

pgsql-performance by date:

Previous
From: Nicolas Even
Date:
Subject: Re: Query with "ILIKE ALL" does not use the index
Next
From: Dinesh Kumar
Date:
Subject: Performance difference in accessing differrent columns in a Postgres Table