Re: Case Insensitive

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(at)jakobs(dot)com
+49 178 9759012 <tel:+491789759012> oder +49 2202 817157
<tel:+492202817157>