Case insensitive

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