Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xr7dl-0006nW-3e for pgsql-admin@arkaria.postgresql.org; Wed, 19 Nov 2014 15:57:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xr7dk-0008AR-JE for pgsql-admin@arkaria.postgresql.org; Wed, 19 Nov 2014 15:57:56 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xr7di-00087Z-Nj for pgsql-admin@postgresql.org; Wed, 19 Nov 2014 15:57:54 +0000 Received: from mail2.sdb.it ([85.37.147.67]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xr7dY-0001Nl-Qk for pgsql-admin@postgresql.org; Wed, 19 Nov 2014 15:57:52 +0000 Received: by mail2.sdb.it (Postfix, from userid 501) id B8BCB20098; Wed, 19 Nov 2014 16:57:42 +0100 (CET) Received: from geronimo.sdb.it (sdbfi-mh.sdb.it [10.101.1.20]) by mail2.sdb.it (Postfix) with ESMTP id 91890200A3; Wed, 19 Nov 2014 16:57:42 +0100 (CET) Received: from mailtech.sdb.it (localhost.localdomain [127.0.0.1]) by geronimo.sdb.it (Postfix) with ESMTP id 8AA49D800E; Wed, 19 Nov 2014 16:57:42 +0100 (CET) Received: from [127.0.0.1] (pcsilviob2.sdb.it [10.118.101.111]) by mailtech.sdb.it (Postfix) with ESMTPA id 8BBFA8F0; Wed, 19 Nov 2014 16:57:42 +0100 (CET) Message-ID: <546CBDF1.2030007@tech.sdb.it> Date: Wed, 19 Nov 2014 16:57:37 +0100 From: Silvio Brandani User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 MIME-Version: 1.0 To: Albe Laurenz , "pgsql-admin@postgresql.org" Subject: Re: order by query wrong result References: <546CA188.705@tech.sdb.it> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Private-Material: Please read notice X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Hi, lc_collate ------------- en_US.UTF-8 server_encoding ----------------- UTF8 we are on postgres 9.3.5 on Centos 6.5 Thanks Silvio Brandani Il 19/11/2014 15:25, Albe Laurenz ha scritto: > Silvio Brandani wrote: >> we have a query with wrong result in order by : > Ordering depends on the collation, and that depends on the operating system. > > What are the values of the parameters "lc_collate" and "server_encoding" of your database? > What is your operating system? > If the column you order by is defined with a nonstandard collation, > what is that collation? > > Yours, > Laurenz Albe -------------------------------------------------------------------------------- This message is for the recipients only. If you receive it in error, please notify the sender and delete it together with any attachments. For any further information, including our privacy policy please refer to http://www.savinodelbene.com/privacy/ -------------------------------------------------------------------------------- -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin