Re: Case Insensitive

On Thu, 28 Mar, 2019, 4:28 PM Andreas Kretschmer, <andreas(at)a-kretschmer(dot)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
>
>
>
>