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?
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
In response to
pgsql-hackers by date
|Next:||From: Andreas 'ads' Scherbaum||Date: 2008-06-02 20:40:47|
|Subject: Re: Core team statement on replication in PostgreSQL|
|Previous:||From: Simon Riggs||Date: 2008-06-02 19:47:11|
|Subject: Re: Outer joins and equivalence|