Thread: Case insensitive

Hi:

Do anyone have any idea to configure the postgresql so that it can perform
case-insensitive matching automatically? [other than--select * from table
where lower(col_value) = lower(pattern)]

Thanks!
Carmen

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

On Sat, 2002-08-10 at 16:22, Carmen Wai wrote:
> Hi:
>
> Do anyone have any idea to configure the postgresql so that it can perform
> case-insensitive matching automatically? [other than--select * from table
> where lower(col_value) = lower(pattern)]

You can use ILIKE  (WHERE col ILIKE 'pattern')

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "If ye abide in me, and my words abide in you, ye shall
      ask what ye will, and it shall be done unto you."
                                      John 15:7