COLLATE - Mailing list pgsql-general

From Filip Rembiałkowski
Subject COLLATE
Date
Msg-id 92869e660606050804m79c5d269t69d4ef655214624b@mail.gmail.com
Whole thread Raw
Responses Re: COLLATE  (Martijn van Oosterhout <kleptog@svana.org>)
Re: COLLATE  (Greg Stark <gsstark@mit.edu>)
Re: COLLATE  (Jan Behrens <jan.behrens@flexiguided.de>)
List pgsql-general
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?

are there any "partial" solutions to the problem?

regards,

Filip Rembiałkowski

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: create view problem
Next
From: Adam Witney
Date:
Subject: Re: does this mean i have a corruption?