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

Re: Patch for collation using ICU

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: Palle Girgensohn <girgen(at)pingpong(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, John Hansen <john(at)geeknet(dot)com(dot)au>,Andrew Dunstan <andrew(at)dunslane(dot)net>
Subject: Re: Patch for collation using ICU
Date: 2005-03-27 01:34:03
Message-ID: 1111887244.5524.2.camel@fuji.krosing.net (view raw or flat)
Thread:
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(at)tm(dot)ee>

In response to

Responses

pgsql-hackers by date

Next:From: Stephan SzaboDate: 2005-03-27 01:40:01
Subject: Re: Patch for collation using ICU
Previous:From: Palle GirgensohnDate: 2005-03-27 00:50:03
Subject: Re: Patch for collation using ICU

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