Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id EBD8163555E for ; Tue, 1 Sep 2009 18:39:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15164-02-2 for ; Tue, 1 Sep 2009 21:39:06 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f216.google.com (mail-ew0-f216.google.com [209.85.219.216]) by mail.postgresql.org (Postfix) with ESMTP id 1CE1E634AEC for ; Tue, 1 Sep 2009 18:38:39 -0300 (ADT) Received: by ewy12 with SMTP id 12so258293ewy.24 for ; Tue, 01 Sep 2009 14:38:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=PblaENW9Mod4k0bUzN55lfWRa30VBjF0u6sjBDKO/CA=; b=CAowXxt1UBgTiutRg7iWlAxvR9V4+OZuRySGi782sucsFcQTWR2PjY5JwkhT8YVynY BUmWZXaLyCsSmGb9sNTMD40aAGWIl/Dkbk0CFPaNJcpa7w9bPDgWSQJTQ49NXVO1fgEZ Tqn4jxuV6f0MP1QHYV5MQVd8EATmJ65fKLMYM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=FysT7A+xhl9etApzYVLyNSRhsj4L2eoynUBhsbHMDgSLgGM0RlSj/4lSdQmt/mWvyn AkmbxAWEft1UOV4GyWe/fQr4LMtzMqNz2QLBYR/SEPeWBnQB5qgoGC9ex4XaDTpS5+SR xPYmCYsYTGVfCj5sb0fQV29CmxZs70rH+Vuk0= MIME-Version: 1.0 Received: by 10.210.129.17 with SMTP id b17mr6787885ebd.86.1251841117746; Tue, 01 Sep 2009 14:38:37 -0700 (PDT) In-Reply-To: <4A9D8BC4.30906@gmail.com> References: <4A9D8BC4.30906@gmail.com> Date: Tue, 1 Sep 2009 15:38:32 -0600 Message-ID: Subject: Re: Odd sort behaviour From: Scott Marlowe To: Rob Sargent Cc: "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.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200909/6 X-Sequence-Number: 33071 On Tue, Sep 1, 2009 at 3:01 PM, Rob Sargent wrote: > Since when does "." sort as "nothing at all" Since you set your locale equal to something like en_US instead of C