Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
eid | ename-----+------- 1 | aaa 2 | AAA 3 | áäâ 4 | āåȧ
On Mar 28, 2019, at 4:26 AM, Ben Madin <ben@ausvet.com.au> wrote:Or you can just use `ilike`:SELECT * FROM emp WHERE ename ilike 'aaa';https://www.postgresql.org/docs/10/sql-select.html#SQL-WHEREcheersBenOn Thu, 28 Mar 2019 at 16:24, Sameer Kumar <sameer.kumar@ashnik.com> wrote: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-- Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICDManaging DirectorMobile:+61 448 887 220E-mail:ben@ausvet.com.auWebsite:www.ausvet.com.auSkype: benmadinAddress: 5 Shuffrey StreetFremantle, WA 6160Australia
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 по дате отправления: