In the postgresql manual you find some stuff like ILIKE here:
http://www.postgresql.org/idocs/index.php?functions-matching.html
Andreas Schlegel wrote:
> Hi,
>
> is there a flag to set which determines if queries run successful with a
> case sensitive or case insensitive WHERE clause:
>
> For example: if I have a name1 colum with a value 'Test' I would like to
> search for 'test' and get also this row
> (select * from tTest where name1='test')
>
> Greetings,
> Andreas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org