Re: Case Insensitive

[Holger Jakobs <holger@xxxxxxxxxx>]

Yes, you can use the data type citext

https://www.postgresql.org/docs/current/citext.html

If you don't want to do this, you will have to compare where lower(ename)='aaa'

Am 28.03.19 um 09:20 schrieb Sridhar N Bamandlapally:

Hi PG-General and Pgsql-Admin

Can we achieve CASE INSENSITIVE in PostgreSQL?

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

Thanks

Sridhar

--

Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@xxxxxxxxxx
+49 178 9759012 oder +49 2202 817157