X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 44CE19DCE4C for ; Sun, 26 Mar 2006 12:20:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37927-09 for ; Sun, 26 Mar 2006 12:20:48 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id CC9B39DCCAB for ; Sun, 26 Mar 2006 12:20:47 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k2QGKdSA026549; Sun, 26 Mar 2006 11:20:39 -0500 (EST) To: Erwin Brandstetter cc: pgsql-admin@postgresql.org, peter_e@gmx.net Subject: Re: database locale and system locale In-reply-to: <44265C08.8040301@falter.at> References: <442624FF.6000604@falter.at> <200603261024.00755.peter_e@gmx.net> <44265C08.8040301@falter.at> Comments: In-reply-to Erwin Brandstetter message dated "Sun, 26 Mar 2006 11:16:56 +0200" Date: Sun, 26 Mar 2006 11:20:39 -0500 Message-ID: <26548.1143390039@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.114 required=5 tests=[AWL=0.114] X-Spam-Score: 0.114 X-Spam-Level: X-Archive-Number: 200603/272 X-Sequence-Number: 21029 Erwin Brandstetter writes: > Wait .. not that great! The system locale is more or less ignored, but > my sort order will approach randomness? Peter's point is that a given locale setting will expect a particular encoding, and if you try to use a different encoding then your sort ordering will be wrong. Not "random" exactly, but not what you want. regards, tom lane