Case insensitive

From: "Carmen Wai" <wai_carmen(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Case insensitive
Date: 2002-08-10 15:22:10
Message-ID: F224zTS6GDa7jp2L4VK00005cfa@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2002-08-10 15:59:05 Re: Case insensitive
Previous Message Carmen Wai 2002-08-10 15:14:13 libpq