Re: Per-column collation, proof of concept - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Per-column collation, proof of concept
Date
Msg-id 1279141904.30100.4.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: Per-column collation, proof of concept  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Per-column collation, proof of concept
List pgsql-hackers
On ons, 2010-07-14 at 19:35 +0200, Pavel Stehule wrote:
> I have only one question - If I understand well you can use collate
> just for sort. What is your plan for range search operation?

My patch does range searches.  Sorting uses the same operators, so both
will be supported.  (Sorting is not yet implemented, as I had written.)

> Sort is
> interesting and I am sure important for multilangual applications, for
> me - more important is case sensitive, case insensitive, accent
> sensitive, insensitive filtering - do you have a plan for it?

You may be able to do some of these by using appropriate locale
definitions.  I'd need some examples to be able to tell for sure.

> what about DISTINCT clause, maybe GROUP BY clause ?

DISTINCT and GROUP BY work with equality, which is not affected by
locales (at least under the current rules).




pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: PgWest 2010 Call for Papers!
Next
From: marcin mank
Date:
Subject: Re: cross column correlation revisted