Home > mailing lists

Re: Case Insensitive - Mailing list pgsql-general

From	Ben Madin
Subject	Re: Case Insensitive
Date	March 28, 2019 11:26:30
Msg-id	CA+weYr33E8EuntzGdwApB2Qgrj+EZ_djtv-r0wn06yYDuLGfrQ@mail.gmail.com Whole thread Raw
In response to	Re: Case Insensitive (Sameer Kumar <sameer.kumar@ashnik.com>)
Responses	Re: Case Insensitive (Andy Anderson <aanderson@amherst.edu>) Re: Case Insensitive (Andy Anderson <aanderson@amherst.edu>)
List	pgsql-general

Tree view

Or you can just use `ilike`:

SELECT * FROM emp WHERE ename ilike 'aaa';

https://www.postgresql.org/docs/10/sql-select.html#SQL-WHERE

cheers

Ben

On Thu, 28 Mar 2019 at 16:24, Sameer Kumar <sameer.kumar@ashnik.com> wrote:

On Thu, 28 Mar, 2019, 4:20 PM Sridhar N Bamandlapally, <sridhar.bn1@gmail.com> wrote:
Hi PG-General and Pgsql-Admin

Can we achieve CASE INSENSITIVE in PostgreSQL?

You are perhaps migrating from another RDBMS where this kind of feature is considered a feature.

I mean, need below way

postgres=# select * from emp;
eid | ename
-----+-------
1 | aaa
2 | AAA
(2 rows)

postgres=# select * from emp where ename='aaa';
eid | ename
-----+-------
1 | aaa
2 | AAA
(2 rows)
--above result is just an manual made example only

You can write a query with upper function:

select * from emp where upper(ename)=upper('aaa');

Or you can overload the "=" operator for text arguements.

Thanks
Sridhar