Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xr6Dy-0003l3-KN for pgsql-admin@arkaria.postgresql.org; Wed, 19 Nov 2014 14:27:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xr6Dy-0003oW-4N for pgsql-admin@arkaria.postgresql.org; Wed, 19 Nov 2014 14:27:14 +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 1Xr6Dw-0003mB-P5 for pgsql-admin@postgresql.org; Wed, 19 Nov 2014 14:27:12 +0000 Received: from proofpoint1.mail.rice.edu ([128.42.201.100] helo=pp1.rice.edu) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1Xr6Dr-0008NQ-3r for pgsql-admin@postgresql.org; Wed, 19 Nov 2014 14:27:11 +0000 Received: from pps.filterd (pp1.rice.edu [127.0.0.1]) by pp1.rice.edu (8.14.5/8.14.5) with SMTP id sAJEMj0K021125; Wed, 19 Nov 2014 08:27:01 -0600 Received: from mh3.mail.rice.edu (mh3.mail.rice.edu [128.42.199.10]) by pp1.rice.edu with ESMTP id 1qn5y9aphr-1; Wed, 19 Nov 2014 08:27:00 -0600 X-Virus-Scanned: by amavis-2.7.0 at mh3.mail.rice.edu, auth channel X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.rice.edu (aart.rice.edu [168.7.56.48]) by mh3.mail.rice.edu (Postfix) with ESMTP id 9DF3F40404; Wed, 19 Nov 2014 08:27:00 -0600 (CST) Received: by aart.rice.edu (Postfix, from userid 18612) id 932EC100339; Wed, 19 Nov 2014 08:27:00 -0600 (CST) Date: Wed, 19 Nov 2014 08:27:00 -0600 From: "ktm@rice.edu" To: Scott Ribe Cc: jayknowsunix@gmail.com, Silvio Brandani , "pgsql-admin@postgresql.org" Subject: Re: order by query wrong result Message-ID: <20141119142700.GI10679@aart.rice.edu> References: <546CA188.705@tech.sdb.it> <98519DF5-9539-434F-916B-BFF33F24A6A5@elevated-dev.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <98519DF5-9539-434F-916B-BFF33F24A6A5@elevated-dev.com> User-Agent: Mutt/1.5.20 (2009-12-10) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 suspectscore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=7.0.1-1402240000 definitions=main-1411190111 X-Pg-Spam-Score: -2.6 (--) 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 On Wed, Nov 19, 2014 at 07:13:56AM -0700, Scott Ribe wrote: > On Nov 19, 2014, at 7:07 AM, jayknowsunix@gmail.com wrote: > > > > That doesn't look like an error to me. The upper() function is only converting your name field to upper case and then the "order by" is simply alphabetical based on that, which is what your return values are. > > No, they're not--look again. > -- > Scott Ribe > scott_ribe@elevated-dev.com > http://www.elevated-dev.com/ > (303) 722-0567 voice They are based on your locale. Regards, Ken -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin