COLLATE

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: COLLATE
Date: 2006-06-05 15:04:25
Message-ID: 92869e660606050804m79c5d269t69d4ef655214624b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: COLLATE at 2006-06-05 16:03:34 from Martijn van Oosterhout
  • Re: COLLATE at 2006-06-05 16:53:57 from Greg Stark
  • Re: COLLATE at 2006-06-14 12:51:31 from Jan Behrens

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-06-05 16:03:34 Re: COLLATE
Previous Message Adam Witney 2006-06-05 15:02:20 Re: does this mean i have a corruption?