Re: Patch for collation using ICU - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Patch for collation using ICU
Date
Msg-id 1111887244.5524.2.camel@fuji.krosing.net
Whole thread Raw
In response to Re: Patch for collation using ICU  (Palle Girgensohn <girgen@pingpong.net>)
Responses Re: Patch for collation using ICU  (Palle Girgensohn <girgen@pingpong.net>)
List 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>


pgsql-hackers by date:

Previous
From: "Reini Urban"
Date:
Subject: Re: minor windows & cygwin regression failures on stable
Next
From: "Andrew Dunstan"
Date:
Subject: Re: minor windows & cygwin regression failures on stable