Re: LC_COLLATE and index usage - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: LC_COLLATE and index usage
Date
Msg-id 20030508022448.A15390@hermes.hilbert.loc
Whole thread Raw
In response to Re: LC_COLLATE and index usage  (Dennis Gearon <gearond@cvc.net>)
Responses Re: LC_COLLATE and index usage  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
>     I'd like to see LOCALE done away with, everything be in UTF-8, and have
> a POSGRES extension that sets the sort order as an itemized listing of
> mime type languages like:
>
>     SET COLLATION( en-us, fr, ru ).
>
> Everything NOT in those character sets, falls below them in the sort
> order, but stays in it's tabular order, otherwise.
Sure, I don't care either way as long as I get indexes on my
localized sort order (I do know I don't have a right to
request that unless I offer a patch ;-)

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: Ralph Graulich
Date:
Subject: Re: LC_COLLATE and index usage
Next
From: Alvaro Herrera
Date:
Subject: Re: LC_COLLATE and index usage