From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Case Insensitive |
Date: | 2019-03-28 08:28:38 |
Message-ID: | bc8b3f30-81d9-ae89-619c-de6af8ac23a8@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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)
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2019-03-28 08:29:55 | Re: Case Insensitive |
Previous Message | Murtuza Zabuawala | 2019-03-28 08:27:28 | Re: Case Insensitive |
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2019-03-28 08:29:55 | Re: Case Insensitive |
Previous Message | Murtuza Zabuawala | 2019-03-28 08:27:28 | Re: Case Insensitive |