Home > mailing lists

Case Insensitive - Mailing list pgsql-general

From	Sridhar N Bamandlapally
Subject	Case Insensitive
Date	March 28, 2019 11:20:07
Msg-id	CAGuFTBU1fACZWYdVwU-HiBJWAt2QFRa9fkB+SovmVMoUjVbekw@mail.gmail.com Whole thread Raw
Responses	Re: Case Insensitive Re: Case Insensitive Re: Case Insensitive Re: Case Insensitive Re: Case Insensitive Re: Case Insensitive Re: Case Insensitive Re: Case Insensitive Re: Case Insensitive
List	pgsql-general

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

From: "David G. Johnston"
Date: 27 March 2019, 19:37:03
Subject: Re: Is it possible to have a cascade upwards query?

From: Sameer Kumar
Date: 28 March 2019, 11:23:52
Subject: Re: Case Insensitive