Horton

Re: Patch for collation using ICU

Hannu Krosing <hannu@tm.ee>

View thread
From: Hannu Krosing <hannu@tm.ee>
To: Palle Girgensohn <girgen@pingpong.net>
Cc: pgsql-hackers@postgresql.org, John Hansen <john@geeknet.com.au>, Andrew Dunstan <andrew@dunslane.net>
Date: 2005-03-27T01:34:03Z
Lists: pgsql-hackers 
On L, 2005-03-26 at 03:09 +0100, Palle Girgensohn wrote:

> Hi!
> 
...
> I've noticed a couple of things about using the ICU patch vs. pristine 
> pg-8.0.1:
> 
> - ORDER BY is case insensitive when using ICU. This might break the SQL 
> standard (?), but sure is nice :)

How does your patch interact with the ability to use indexes for
anchored LIKE or regex (i.e. can "name LIKE 'start%'" still use index) ?

-- 
Hannu Krosing <hannu@tm.ee>