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
