Skip site navigation (1) Skip section navigation (2)

Re: Case-Insensitve Text Comparison

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, Andrew Sullivan <ajs(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Case-Insensitve Text Comparison
Date: 2008-06-02 19:50:32
Message-ID: 48444F08.4050505@Sheeky.Biz (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
To diverge a little -

Bit of a nood question along these lines -

Does LIKE and ILIKE take into consideration the locale allowing 
insensitive searches in any locale setting?

I know that LIKE can use an index if you don't start the match with a 
wild card. ILIKE doesn't seem to. Is or would it be possible to get 
ILIKE to use a properly configured index as well?


Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

In response to

pgsql-hackers by date

Next:From: Andreas 'ads' ScherbaumDate: 2008-06-02 20:40:47
Subject: Re: Core team statement on replication in PostgreSQL
Previous:From: Simon RiggsDate: 2008-06-02 19:47:11
Subject: Re: Outer joins and equivalence

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group