Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 08666633EAD for ; Fri, 8 May 2009 16:17:10 -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 77582-03 for ; Fri, 8 May 2009 16:17:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.30]) by mail.postgresql.org (Postfix) with ESMTP id 22B3D632209 for ; Fri, 8 May 2009 16:17:06 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 8so919971yxg.73 for ; Fri, 08 May 2009 12:17:06 -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 :content-transfer-encoding; bh=3M4T8HQWyGPxSDwpycM5M+6F2erpppjrvDM3Lj7m3lQ=; b=cm2h4TV8tkMY57hbu3Y4NqEdxeGsigWZOymz2UNdaj/4G0FhpM6mVK5JOD4U/iOeKO IbMJUJFJWo5oSf/Zcc2v7roZsG6xUsvXQYKPudM8oTMyotOrDwAQA/cl4D/bGJlhrMXs VC8ctbBleMM/uGM776+3uG4ciJagZHmxZSzaY= 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:content-transfer-encoding; b=t0Fwqp74kQolfArWYp52GkzLtWXYBm8Dy8SN+LvGDo3oDMKf6S6JD1WxliHFZECyiY kCKG8zOoGMpCR34mvy17wDNFihQECdO7MrrGLje1I5tQHSFKkkqCRerLabrdoealMoJB v49IEu2j8MMIlmUg5ztVOOGruGmX0tuwaFEoo= MIME-Version: 1.0 Received: by 10.90.65.14 with SMTP id n14mr3336094aga.108.1241809736511; Fri, 08 May 2009 12:08:56 -0700 (PDT) In-Reply-To: <10924.1241805448@sss.pgh.pa.us> References: <4544e0330905081026u36b29014i43f1fc85d048916f@mail.gmail.com> <10924.1241805448@sss.pgh.pa.us> Date: Fri, 8 May 2009 14:08:56 -0500 Message-ID: <4544e0330905081208j306fee6o4c22ecd6d63c3bae@mail.gmail.com> Subject: Re: ascii-betical sort order? From: Peter Koczan To: Tom Lane , Kenneth Marshall Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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/36 X-Sequence-Number: 32528 On Fri, May 8, 2009 at 12:57 PM, Tom Lane wrote: > You're apparently using a non-C locale ... you need to re-initdb in > C locale. On Fri, May 8, 2009 at 12:58 PM, Kenneth Marshall wrote: > Try looking under Localization in the manual (Chapter 22). Excellent, just what I was looking for. I'll look at this when I have a bit more time. Thanks, Peter