Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
On Thu, 28 Mar, 2019, 4:20 PM Sridhar N Bamandlapally, <sridhar.bn1@gmail.com> wrote:Hi PG-General and Pgsql-AdminCan we achieve CASE INSENSITIVE in PostgreSQL?You are perhaps migrating from another RDBMS where this kind of feature is considered a feature.I mean, need below waypostgres=# select * from emp; eid | ename-----+------- 1 | aaa 2 | AAA(2 rows)postgres=# select * from emp where ename='aaa'; eid | ename-----+------- 1 | aaa 2 | AAA(2 rows)--above result is just an manual made example onlyYou can write a query with upper function:select * from emp where upper(ename)=upper('aaa');Or you can overload the "=" operator for text arguements.ThanksSridhar
Hi PG-General and Pgsql-AdminCan we achieve CASE INSENSITIVE in PostgreSQL?
I mean, need below waypostgres=# select * from emp; eid | ename-----+------- 1 | aaa 2 | AAA(2 rows)postgres=# select * from emp where ename='aaa'; eid | ename-----+------- 1 | aaa 2 | AAA(2 rows)--above result is just an manual made example only
ThanksSridhar
В списке pgsql-general по дате отправления: