Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I would like to match {[email protected]} with {[email protected], [email protected]}

Doing the case sensitive query is each enough:

select * from users where email @> '{[email protected]}'

However, I cannot find a way to run a case insensitive contains query against an array column.

This page does not instill confidence that this is possible, as there is no mention of case sensitivity. Any thoughts?

share|improve this question
So email is an array, correct? – mu is too short 9 mins ago

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.