Re: Case Insensitive
Re: Case Insensitive
От:
Holger Jakobs <holger@jakobs.com>
Дата:
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-AdminCan we achieve CASE INSENSITIVE in PostgreSQL?I mean, need below waypostgres=# select * from emp;eid | ename-----+-------1 | aaa2 | AAA(2 rows)postgres=# select * from emp where ename='aaa';eid | ename-----+-------1 | aaa2 | AAA(2 rows)--above result is just an manual made example onlyThanksSridhar
--
Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@jakobs.com
+49 178 9759012 oder +49 2202 817157