Thank you Tom
On 26 July 2018 at 18:44, Tom Lane wrote:
> Nicolas Even 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['
Hi Matthew,
I finally used "WHERE name ILIKE arr[1] AND name ILIKE ALL(arr)" which
works well enough for my use case.
Thank you
Nicolas
On 26 July 2018 at 19:22, Matthew Hall wrote:
> On Jul 26, 2018, at 9:44 AM, Tom Lane wrote:
>>
>> Nicolas Even writes:
>>&g
Hi,
I have the following table:
Table "public.totoz"
Column | Type | Collation | Nullable | Default
---+--+---+--+-
name | character varying(512) | | not null |
Indexes:
