From: jack <datactrl@tpg.com.au>
To: pgsql-sql@postgresql.org
Subject: data order problem
Date: Mon, 15 Apr 2002 13:19:15 +1000
Message-ID: <000e01c1e42c$537205c0$1400a8c0@jac> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: datactrl@tpg.com.au
Subject: Re: data order problem
In-Reply-To: <000e01c1e42c$537205c0$1400a8c0@jac>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox