data order problem

From: "jack" <datactrl(at)tpg(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: data order problem
Date: 2002-04-15 03:19:15
Message-ID: 000e01c1e42c$537205c0$1400a8c0@jac
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

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 '<ABC>', it goes to last one when you do the same query.

Thank you!

JACK

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Chris 2002-04-15 03:42:02 problems with website
Previous Message P. Jourdan 2002-04-14 19:56:02 Re: plpgsql and createlang?

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-04-15 04:53:02 Re: data order problem
Previous Message Tom Lane 2002-04-13 17:00:38 Re: to_char problem