Is there a way to do a case-insensitive in list

[tnrich]

Aka is there some way we can we do something like:

{_in: ["someTEXT", "SOMEotherText"] }

and have

"SOMETEXT" and "someothertext" 

be returned?

[robertjdominguez]

@tnrich — sorry for the delay!

This should be possible using native queries.

Something like this, maybe?

CREATE OR REPLACE FUNCTION case_insensitive_in(text[], text)
RETURNS BOOLEAN AS $$
SELECT $2 ILIKE ANY ($1);
$$ LANGUAGE sql;

A simpler approach may be to use ilike, but I'm not sure if it will work with arrays like you've outlined.