Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57]) by postgresql.org (Postfix) with ESMTP id D0AA8475F3F for ; Mon, 15 Apr 2002 00:34:11 -0400 (EDT) Received: from jac (bri2-56k-036.tpgi.com.au [203.29.144.36]) by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id g3F3JHd25057 for ; Mon, 15 Apr 2002 13:19:17 +1000 Message-ID: <000e01c1e42c$537205c0$1400a8c0@jac> From: "jack" To: Subject: data order problem Date: Mon, 15 Apr 2002 13:19:15 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/171 X-Sequence-Number: 7435 Hi, all I use psql v7.2. I have a table which has one column called suburb( and primary key as well) and data is such as.. THE AAA THE BBB THE CDD THECCC After I do select * from xxx order by suburb; It shows as.. THE AAA THE BBB THECCC THE CDD 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. Thank you! JACK