3 ms·
I'm no Postgres master by any means, but I searched it: https://duckduckgo.com/?q=postgres+case+insensitive+query https://duckduckgo.com/?q=postgres+case+insens
by metalliqaz 9y ago
I'm no Postgres master by any means, but I searched it: https://duckduckgo.com/?q=postgres+case+insensitive+query https://duckduckgo.com/?q=postgres+case+insensitive+query
solution immediately came up at SO:
SELECT id FROM users WHERE LOWER(email)=LOWER('Foo@example.com')
- irrational 9y agoThat only works if you are only dealing with English. I've posted a comment with a solution that works across all languages.