Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 501D063415B for ; Sat, 9 May 2009 16:21:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 93578-02 for ; Sat, 9 May 2009 16:21:15 -0300 (ADT) X-Greylist: delayed 00:05:26.266721 by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.29]) by mail.postgresql.org (Postfix) with ESMTP id F1ED863404B for ; Sat, 9 May 2009 16:21:18 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so1207151yxg.73 for ; Sat, 09 May 2009 12:21:18 -0700 (PDT) MIME-Version: 1.0 Received: by 10.151.125.5 with SMTP id c5mr7729276ybn.171.1241896551371; Sat, 09 May 2009 12:15:51 -0700 (PDT) In-Reply-To: <6111.1241879627@sss.pgh.pa.us> References: <6111.1241879627@sss.pgh.pa.us> Date: Sat, 9 May 2009 15:15:51 -0400 X-Google-Sender-Auth: 7079c8108868c447 Message-ID: Subject: Re: Distinct oddity From: Glenn Maynard To: pgsql-sql@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200905/42 X-Sequence-Number: 32534 On Sat, May 9, 2009 at 10:33 AM, Tom Lane wrote: > That only proves that adding the 'e' changes the sort order, which is > completely unsurprising for any non-C locale. What you need to do is > dump out the *entire* results of the DISTINCT queries and look for the > unmatched lines. I'd try dumping to two files, stripping the 'e' with > sed, and then sort/diff. How could adding an "e" change the sorting of "=C3=96sterreich/Welt (Ltg.)" compared to "=C5=A0sterreichisches Verkehrsb ro AG" in de_DE or en_US (or any locale)? It's also odd that the "1. Mittelschule ..." line is getting sorted after t= hose. --=20 Glenn Maynard