Re: Sorting Problem - Mailing list pgsql-general

From Dennis Björklund
Subject Re: Sorting Problem
Date
Msg-id Pine.LNX.4.44.0308131045390.2191-100000@zigo.dhs.org
Whole thread Raw
In response to Re: Sorting Problem  ("Maksim Likharev" <mlikharev@aurigin.com>)
Responses Re: Sorting Problem  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
On Tue, 12 Aug 2003, Maksim Likharev wrote:

> If you are talking about everything that lies under so called LATIN-1 (
> ISO-8859-1 ) en_US encapsulates ( at least suppose to ) all those
> sorting rules, do not remember about accents tho.

It does not work like that. Different countries in europe that all use
latin1 use different sort order for the same characters. There is no way
to have one set of rules work for all. If we take swedish for example,
then v and w is treatead as the same letter when sorting. So in a
dictionary all words beginning with v or w is mixed together.

In the future we need indexes that depend on the locale (and a lot of
other changes).

--
/Dennis


pgsql-general by date:

Previous
From: Jade
Date:
Subject: postgres as an snmp client
Next
From: Alexander Rüegg
Date:
Subject: Tsearch2 lexeme position