Avram currently supports Array(String), but if you need to search an array with case insensitive, then things get a little hairy
(assuming you have a GIN index on this column...)
=# select username from users where tags @> array['Lucky'];
username
-------------
jeremy
(1 row)
Time: 0.438 ms
=# select username from users where tags @> array['LUCKY'];
username
-------------
(0 rows)
Time: 0.815 ms
=# select username from users where lower(tags::text)::text[] @> array['lucky'];
username
-------------
jeremy
(1 row)
Time: 36.088 ms
Now if you use a citext[] column instead..
=# select username from users where tags @> array['LUCKY']::citext[];
username
-------------
jeremy
(1 row)
Time: 0.395 ms
=# select username from users where tags @> array['lUcKy']::citext[];
username
-------------
jeremy
(1 row)
Time: 0.408 ms
Avram currently supports
Array(String), but if you need to search an array with case insensitive, then things get a little hairy(assuming you have a GIN index on this column...)
Now if you use a
citext[]column instead..