Re: [pgadmin-support] Postgres case insensitive searches

2013-07-01 Thread Albe Laurenz
bhanu udaya wrote: >>> What is the best way of doing case insensitive searches in postgres using >>> Like. >> >> Table "laurenz.t" >> Column | Type | Modifiers >> +-+--- >> id | integer | not null >> val | text | not null >> Indexes: >> "t_pkey" PRIMARY KEY, btree (id) >> >

Re: [pgadmin-support] Postgres case insensitive searches

2013-06-28 Thread bhanu udaya
Thanks. But, I do not want to convert into upper and show the result. Example, if I have records as below: id type 1. abcd 2. Abcdef 3. ABcdefg 4. aaadf The below query should report all the above select * from table where type like 'ab%'. It should get all above 3 records. Is there a way

[pgadmin-support] Postgres case insensitive searches

2013-06-28 Thread bhanu udaya
Hello, Grettings, What is the best way of doing case insensitive searches in postgres using Like. Ilike - does not use indexes function based indexes are not as fast as required. CITEXT - it still taking 600 ms - 1 second on a 2.2 million rows... does not use index Collation Indexes creatio