Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e8B0ZUf93720; Sun, 10 Sep 2000 20:35:30 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id UAA05413; Sun, 10 Sep 2000 20:35:18 -0400 (EDT) To: Max Pyziur cc: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org, pgsql-bugs@hub.org Subject: Re: [BUGS] "ORDER BY" issue - is this a bug? In-reply-to: <39BBD09C.C8F6B3F8@panix.com> References: <39BBD09C.C8F6B3F8@panix.com> Comments: In-reply-to Max Pyziur message dated "Sun, 10 Sep 2000 14:19:08 -0400" Date: Sun, 10 Sep 2000 20:35:18 -0400 Message-ID: <5410.968632518@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200009/15 Max Pyziur writes: > I've come across what I consider an odd sorting anomaly in 7.0.2-2 where running > the following query: > select headline from headlines where headline like 'Alb%' order by 1 ; > The results in the 7.0.2-2 install come back case-insensitive and > oblivious to punctuation. That's pretty bizarre (not to say difficult to believe). What LOCALE setting are you running the postmaster in? regards, tom lane