Postgres Pro
Downloads
Home   >   mailing lists

Case Insensitive - Mailing list pgsql-general

From Sridhar N Bamandlapally
Subject Case Insensitive
Date
Msg-id CAGuFTBU1fACZWYdVwU-HiBJWAt2QFRa9fkB+SovmVMoUjVbekw@mail.gmail.com
Whole thread Raw
Responses Re: Case Insensitive  (Sameer Kumar <sameer.kumar@ashnik.com>)
Re: Case Insensitive  (Sameer Kumar <sameer.kumar@ashnik.com>)
Re: Case Insensitive  (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>)
Re: Case Insensitive  (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>)
Re: Case Insensitive  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: Case Insensitive  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Re: Case Insensitive  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Re: Case Insensitive  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
Re: Case Insensitive  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Is it possible to have a cascade upwards query?
Next
From: Sameer Kumar
Date:
Subject: Re: Case Insensitive