luckyframework/avram
Support Array of citext `citext[]` column
Aberta
#970 aberto em 11 de set. de 2023
hacktoberfest
Métricas do repositório
- Stars
- (180 estrelas)
- Métricas de merge de PR
- (Métricas PR pendentes)
Description
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