Re: Postgres case insensitive searches

On 6/28/2013 6:59 PM, bhanu udaya wrote:
> select * from table where type like 'ab%'. It should get all above 3 
> records.  Is there a way the database itself can be made 
> case-insensitive with UTF8 characterset. I tried with character type & 
> collation POSIX, but it did not really help.

use ILIKE



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast