On Thu, 28 Mar, 2019, 4:28 PM Andreas Kretschmer, <andr...@a-kretschmer.de> wrote:
> > > Am 28.03.19 um 09:20 schrieb Sridhar N Bamandlapally: > > Hi PG-General and Pgsql-Admin > > > > Can we achieve CASE INSENSITIVE in PostgreSQL? > > test=# create extension citext; > CREATE EXTENSION > test=*# create table emp (eid int, ename citext); > CREATE TABLE > test=*# insert into emp values (1, 'aaa'); > INSERT 0 1 > test=*# insert into emp values (2, 'AAA'); > INSERT 0 1 > test=*# select * from emp where ename = 'aaa'; > eid | ename > -----+------- > 1 | aaa > 2 | AAA > (2 rows) > Ummm... Will it use an index (a BTree index)? > > Regards, Andreas > > -- > 2ndQuadrant - The PostgreSQL Support Company. > www.2ndQuadrant.com > > > >
