data order problem - Mailing list pgsql-sql

From jack
Subject data order problem
Date
Msg-id 000e01c1e42c$537205c0$1400a8c0@jac
Whole thread Raw
Responses Re: data order problem  ("Josh Berkus" <josh@agliodbs.com>)
List 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






pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: to_char problem
Next
From: "Josh Berkus"
Date:
Subject: Re: data order problem