Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id DFFE9476362 for ; Mon, 15 Apr 2002 00:56:25 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g3F4tuF07193; Mon, 15 Apr 2002 00:55:56 -0400 (EDT) To: "Josh Berkus" Cc: "jack" , pgsql-sql@postgresql.org Subject: Re: data order problem In-reply-to: References: Comments: In-reply-to "Josh Berkus" message dated "Sun, 14 Apr 2002 21:53:02 -0700" Date: Mon, 15 Apr 2002 00:55:56 -0400 Message-ID: <7190.1018846556@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200204/173 X-Sequence-Number: 7437 "Josh Berkus" writes: >> why is it not ordered by ASCII sequence. And I found if I put in a >> data such >> as '', it goes to last one when you do the same query. > I'm sorry, you're going to have to be more explicit. I don't > understand what problem you are having with the order given. I think he's using a non-C locale and expecting C-locale sort order. regards, tom lane