Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xr5kG-0002lF-7S for pgsql-admin@arkaria.postgresql.org; Wed, 19 Nov 2014 13:56:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xr5kF-0002nZ-K0 for pgsql-admin@arkaria.postgresql.org; Wed, 19 Nov 2014 13:56:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xr5kE-0002nP-QX for pgsql-admin@postgresql.org; Wed, 19 Nov 2014 13:56:30 +0000 Received: from mail2.sdb.it ([85.37.147.67]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xr5k9-0007tG-My for pgsql-admin@postgresql.org; Wed, 19 Nov 2014 13:56:29 +0000 Received: by mail2.sdb.it (Postfix, from userid 501) id 2D6CF2008A; Wed, 19 Nov 2014 14:56:24 +0100 (CET) Received: from geronimo.sdb.it (sdbfi-mh.sdb.it [10.101.1.20]) by mail2.sdb.it (Postfix) with ESMTP id 1906620084 for ; Wed, 19 Nov 2014 14:56:24 +0100 (CET) Received: from mailtech.sdb.it (localhost.localdomain [127.0.0.1]) by geronimo.sdb.it (Postfix) with ESMTP id 173E1D8003 for ; Wed, 19 Nov 2014 14:56:24 +0100 (CET) Received: from [127.0.0.1] (pcsilviob2.sdb.it [10.118.101.111]) by mailtech.sdb.it (Postfix) with ESMTPA id 13B938F0 for ; Wed, 19 Nov 2014 14:56:24 +0100 (CET) Message-ID: <546CA188.705@tech.sdb.it> Date: Wed, 19 Nov 2014 14:56:24 +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: pgsql-admin@postgresql.org Subject: order by query wrong result Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Private-Material: Please read notice X-Pg-Spam-Score: 0.8 (/) 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 all, we have a query with wrong result in order by : select * from prova where name ilike 'savino del bene s%' and record_status = 'A' order by upper(name); and we get: Savino Del Bene Santo Domingo Savino Del Bene Singapore Savino Del Bene Singapore - Airport Office Savino Del Bene South Africa - Cape Town Savino Del Bene South Africa - Durban Savino Del Bene South Africa - Johannesburg Savino Del Bene South Africa - Port Elizabeth Savino Del Bene S.p.A. Campogalliano (MO) Savino Del Bene S.p.A. Capodichino Savino Del Bene S.p.A. Firenze Savino Del Bene S.p.A. Genova Savino Del Bene S.p.A. Headquarters Savino Del Bene Spain S.L. - Alicante Savino Del Bene Spain S.L. - Barcelona Savino Del Bene Spain S.L. - Bilbao Savino Del Bene Spain S.L. - Madrid Savino Del Bene Spain S.L. - Palma de Mallorca Savino Del Bene Spain S.L. - Valencia Savino Del Bene Spain S.L. - Valencia Headquarter Savino Del Bene Spain S.L. - Vigo Savino Del Bene S.p.A. Livorno Savino Del Bene S.p.A. Livorno ufficio Genova c/o Spedimar S.r.L. Savino Del Bene S.p.A. Livorno ufficio La Spezia Savino Del Bene S.p.A. Milano Savino Del Bene S.p.A. Montecosaro Scalo Savino Del Bene S.p.A. Montemurlo (PO) Savino Del Bene S.p.A. Napoli Savino Del Bene S.p.A. Osmannoro(FI) Savino Del Bene S.p.A. Oste (PO) Savino Del Bene S.p.A. Padova Savino Del Bene S.p.A. Pietrasanta Savino Del Bene S.p.A. Pisa Savino Del Bene S.p.A. San Miniato Savino Del Bene S.p.A. Torino Savino Del Bene S.p.A. Treviso Savino Del Bene S.p.A. Udine Savino Del Bene S.p.A. Verona Savino Del Bene S.p.A. Vicenza Savino Del Bene Switzerland AG - Basel Savino Del Bene Switzerland - Rancate Each help higly appreciated, Silvio Brandani -------------------------------------------------------------------------------- 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