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 81B599F9EEB for ; Tue, 23 May 2006 04:33:06 -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 21795-01 for ; Tue, 23 May 2006 04:33:00 -0300 (ADT) X-Greylist: delayed 00:06:38.557245 by SQLgrey- Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id 8A3EE9F9CAA for ; Tue, 23 May 2006 04:32:59 -0300 (ADT) Received: (qmail 31008 invoked by uid 540); 23 May 2006 07:36:13 -0000 Received: from 153.19.179.26 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(153.19.179.26):. Processed in 0.066205 secs); 23 May 2006 07:36:13 -0000 Received: from rzgw.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@153.19.179.26) by ns1.peker.com.pl with SMTP; 23 May 2006 07:36:13 -0000 Message-ID: <4472B8ED.7020508@informatyka.gdansk.pl> Date: Tue, 23 May 2006 09:25:33 +0200 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters) Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/307 X-Sequence-Number: 21839 I can't find in the documentation, if it is possible to define our own sort order for already compiled PostgreSQL. I need it, because the best for my now building application were be to build sort with normal LATIN2 sort order (for non alphanumeric chars compatible with ASCII sort order). I saw in the "configure" file, that it is possible to define, what is alpha, what is number and so on, but it is inpossible to administrators of ready for use systems to - always recompile PostgreSQL for only one application. With greetings Adam