Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 57615633FEC for ; Tue, 1 Sep 2009 20:05:27 -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 02450-08 for ; Tue, 1 Sep 2009 23:05:10 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f210.google.com (mail-fx0-f210.google.com [209.85.220.210]) by mail.postgresql.org (Postfix) with ESMTP id 6458F632277 for ; Tue, 1 Sep 2009 20:05:16 -0300 (ADT) Received: by fxm6 with SMTP id 6so415837fxm.19 for ; Tue, 01 Sep 2009 16:05:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:from:date:x-google-sender-auth:message-id:subject:to:cc :content-type; bh=BJPXIEQLHFlMO+Ctn+WB74nJmHzdP2GdZECmCTrm+hg=; b=r/bHag27Z8K7qWy+q+L999smJvnFv9mwhpwe/5zj5AoKlC15O5g98I6jGPup7C3JZb I1lK26CMnP7KhZOsnMVBrjYdUWF1ycLEFivueaATmoKThoaVTWbL6dc0Xl60rl5FWtoS tVS4SqxEIBDhLn1IxnVhevr4zKcfFXDfmjGf0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:from:date :x-google-sender-auth:message-id:subject:to:cc:content-type; b=dx7qN56NvHK0wHgnHCpO5SD1H1y6XRebRrZ3JI7QzRdZv41wHOIYo+8xDl1ejrniTP YLOhw3s+2xQ/GY0BOZNnBicvWAZMHgWPEefcxNvb9/4bo6N8vMHJpizkjeGQSoOUSPt/ WoaoWfFnBYZWCEuu4gjS5gOIXER7wYrcporpE= MIME-Version: 1.0 Received: by 10.103.127.35 with SMTP id e35mr3221343mun.106.1251846314094; Tue, 01 Sep 2009 16:05:14 -0700 (PDT) In-Reply-To: <4A9DA0DD.7010606@gmail.com> References: <4A9D8BC4.30906@gmail.com> <4A9DA0DD.7010606@gmail.com> From: Greg Stark Date: Wed, 2 Sep 2009 00:04:54 +0100 X-Google-Sender-Auth: 39ad57003b50e49e Message-ID: <407d949e0909011604t4613ac5eue8bd8fa65e72abfb@mail.gmail.com> Subject: Re: Odd sort behaviour To: Rob Sargent Cc: Scott Marlowe , "pgsql-sql@postgresql.org" Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.587 tagged_above=-10 required=5 tests=AWL=0.012, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200909/8 X-Sequence-Number: 33073 On Tue, Sep 1, 2009 at 11:31 PM, Rob Sargent wrote: > How many ways might one accidentally do that I wonder. Well most operating system distributions ask you when you install them what region you're in and use a collation for that region. In 8.4 you can check what collation a database is set to use with \l in psql. In 8.3 the entire "cluster" has a single collation which you can see using "show lc_collate". You can see how your system's collations work by running sort: $ LC_ALL=c sort s a.ecke70@gmx.de a.fischedick@t-online.de adrianohazim@hotmail.com adx008@show.org.tw aecheniq@mac.com aelefant@unina.it aeo_tw@hotmail.com aflores3432@gmail.com afried@advancedneurosurgeons.com agave007@comcast.net agelsinger@amirsys.com agis1doc@yahoo.gr $ LC_ALL=en_US sort s adrianohazim@hotmail.com adx008@show.org.tw aecheniq@mac.com a.ecke70@gmx.de aelefant@unina.it aeo_tw@hotmail.com a.fischedick@t-online.de aflores3432@gmail.com afried@advancedneurosurgeons.com agave007@comcast.net agelsinger@amirsys.com agis1doc@yahoo.gr -- greg http://mit.edu/~gsstark/resume.pdf