Re: COLLATE - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: COLLATE
Date
Msg-id 20060605160334.GC27527@svana.org
Whole thread Raw
In response to COLLATE  ("Filip Rembiałkowski" <plk.zuber@gmail.com>)
Responses Re: COLLATE
List pgsql-general
On Mon, Jun 05, 2006 at 05:04:25PM +0200, Filip Rembia??kowski wrote:
> Hi all,
>
> let's assume that we keep Unicode text  data in the column.
> sometimes we want to sort it according to specific collation order.
> how can we force collation when running a query?
> ideal solution would be having SQL92 standard COLLATE clauses in
> SELECT statements. I heard it's work in progress, what's the status?

Yeah, I was working on it but got stuck on the planner/optimiser
changes. In the mean time the tree drifted and lack of interest, which
gets us where we are now...

> are there any "partial" solutions to the problem?

Not that I know of.

Have a ncie day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: What is the point of create or replace view command
Next
From: Greg Stark
Date:
Subject: Re: COLLATE