X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EA4009FB3CA for ; Fri, 18 Aug 2006 02:57:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 17822-10 for ; Fri, 18 Aug 2006 02:57:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id DAF059FB22E for ; Fri, 18 Aug 2006 02:57:47 -0300 (ADT) Received: (qmail invoked by alias); 18 Aug 2006 05:57:46 -0000 Received: from dslb-084-063-116-078.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.116.78] by mail.gmx.net (mp035) with SMTP; 18 Aug 2006 07:57:46 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: RES: RES: Issue on Varchar Ordering Date: Fri, 18 Aug 2006 07:57:43 +0200 User-Agent: KMail/1.9.3 Cc: Alvaro Herrera , Erika Terahata Torres Prada e Silva - MPS References: <5519B95F9CA8B94DA8DE3F0A33375672017BA006@wtdfl055.prevnet> <20060817213206.GF318@alvh.no-ip.org> In-Reply-To: <20060817213206.GF318@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset="ansi_x3.4-1968" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200608180757.44585.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/212 X-Sequence-Number: 22755 Alvaro Herrera wrote: > LC_COLLATE=pt_PT sort << EOF > GABRIEL ALEXANDRE DA SILVA MANICA > GABRIELA JACOBY NOS > GABRIELA HELEDA DE SOUZA > GABRIELA LETICIA BATISTA NUNES > GABRIEL ALCIDES KLIM PERONDI > EOF > > On my system it outputs the order you show above, which shows that my > locale is correctly defined per your expectations. That is absolutely wild. This will indeed return a space-sensitive sort under pt_BR, but not under, say, de_DE. So there is order in this world! (heh) This is on Debian, so the original poster has some configuration or version difference. Please tell OS version, and the output of "SHOW lc_collate". -- Peter Eisentraut http://developer.postgresql.org/~petere/