Case in-sensitive - Mailing list pgsql-sql

Hello:

Can I config the Postgresql so that it can match case in-sensitive pattern
automatically? i.e. I don't need to explicit convert the pattern to lower
case like this: .....WHERE lower(textfield) LIKE lower(pattern)

Thanks a lot!

Carmen

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com