Re: Case Insensitive

[Sameer Kumar <sameer.kumar@xxxxxxxxxx>]

On Thu, 28 Mar, 2019, 4:20 PM Sridhar N Bamandlapally, <sridhar.bn1@xxxxxxxxx> 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