X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 063EE5E4710 for ; Wed, 1 Sep 2004 18:03:48 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78111-07 for ; Wed, 1 Sep 2004 21:03:38 +0000 (GMT) Received: from mail.astudios.com (ns1.astudios.com [66.49.77.3]) by svr1.postgresql.org (Postfix) with ESMTP id 1F6BF5E46CD for ; Wed, 1 Sep 2004 18:03:36 -0300 (ADT) thread-index: AcSQZyoLjlzJlIpzRnujG7XCO1AV5w== Received: from [10.4.13.50] ([66.194.26.150]) by mail.astudios.com with Microsoft SMTPSVC(6.0.3790.0); Wed, 1 Sep 2004 17:03:43 -0400 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181 Message-ID: <41363929.20602@sermonaudio.com> Date: Wed, 01 Sep 2004 17:03:37 -0400 From: "Chris Hoover" User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040812) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Peter Eisentraut" Cc: Subject: Re: Help understanding locale References: <4136178F.3060705@sermonaudio.com> <200409012239.14723.peter_e@gmx.net> In-reply-to: <200409012239.14723.peter_e@gmx.net> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; format=flowed; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 01 Sep 2004 21:03:43.0420 (UTC) FILETIME=[2A04B7C0:01C49067] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/12 X-Sequence-Number: 14715 Would you please be so kind to provide a bit more explanation? How will the sort differ? Are the any good pages out there that would help me understand the ramifications? Thanks, Chris Peter Eisentraut wrote: >Chris Hoover wrote: > > >>with the locale specifically set to C (initdb --locale=C ...). This >>has fixed the index usage problem, but I don't understand what >>ramifications if any it has on my database. Please help me >>understand what this means to me as the dba. >> >> > >The sort order will be different. > > >