Re: Case Insensitive
| От | Sameer Kumar |
|---|---|
| Тема | Re: Case Insensitive |
| Дата | |
| Msg-id | CADp-Sm6sX1e2BDXhVpM=Wep7AopSVEW4-+Xyzf=oiH6JusCCGQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Case Insensitive (Andreas Kretschmer <andreas@a-kretschmer.de>) |
| Ответы |
Re: Case Insensitive
|
| Список | pgsql-general |
On Thu, 28 Mar, 2019, 4:28 PM Andreas Kretschmer, <andreas@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
В списке pgsql-general по дате отправления: