Re: Postgres case insensitive searches - Mailing list pgsql-general

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