X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B147F9FA279 for ; Tue, 23 May 2006 16:07:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 31902-03 for ; Tue, 23 May 2006 16:06:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 035809FA169 for ; Tue, 23 May 2006 16:06:52 -0300 (ADT) Received: from bedrock.cromagnon.com (smtp.cromagnon.com [170.215.19.8]) by svr4.postgresql.org (Postfix) with ESMTP id 61C9C5B5E7E for ; Tue, 23 May 2006 19:06:51 +0000 (GMT) Received: from lt-cservin.cdhps.com (cservin.dsl.visi.com [209.98.143.247]) (authenticated bits=0) by bedrock.cromagnon.com (8.12.8/8.12.8) with ESMTP id k4NJ6ihX026063 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 23 May 2006 14:06:45 -0500 From: Craig Servin Organization: Cro-Magnon To: pgsql-admin@postgresql.org Subject: Re: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters) Date: Tue, 23 May 2006 14:06:43 -0500 User-Agent: KMail/1.9.1 References: <84AAD313D71B1D4F9EE20E739CC3B6EDE974C1@ATLANTIK-CL.intern.digame.de> In-Reply-To: <84AAD313D71B1D4F9EE20E739CC3B6EDE974C1@ATLANTIK-CL.intern.digame.de> X-MailKey: craigkey MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200605231406.43198.cservin@cromagnon.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/330 X-Sequence-Number: 21862 Can you clarify this for me? Does this mean that if we are using UTF-8 as = the=20 encoding a like clause will not use the index unless we specify=20 varchar_pattern_ops as the index operator class? Craig On Tuesday 23 May 2006 03:14, Hakan Kocaman wrote: > Hi, > > i think this explains, what you ment: > http://www.linuxshare.ru/postgresql/manual/creating-cluster.html > http://www.linuxshare.ru/postgresql/manual/charset.html#LOCALE > > So you don't need to set the Locale-Settings on compile-time, > but on initdb-time. > > Also check if this applies to your kinds of query, because with > a non-C Locale you need to define the indices with a different operator- > class to use the indices with like-comparisons. > See > http://www.postgresql.org/docs/8.1/static/indexes-opclass.html > for more details. > > Best regards > > Hakan Kocaman > Software-Development > > digame.de GmbH > Richard-Byrd-Str. 4-8 > 50829 K=F6ln > > Tel.: +49 (0) 221 59 68 88 31 > Fax: +49 (0) 221 59 68 88 98 > Email: hakan.kocaman@digame.de