Hi, Jose
Suppose '_' stands for a space character. The one column table,xxx, contains
following data.
column name is suburb and is set as primary key.
'THE_AAA'
'THE_BBB'
'THE_CDD'
'THECCC'
After I do
"SELECT * FROM xxx ORDER BY suburb;"
I've got this.
'THE_AAA'
'THE_BBB'
'THECCC'
'THE_CDD'
But I expect it should be like ...
'THE_AAA'
'THE_BBB'
'THE_CDD'
'THECCC'
Because, according to ascii code, space character should be smaller than 'C'
----- Original Message -----
From: "Josh Berkus" <josh@agliodbs.com>
To: "jack" <datactrl@tpg.com.au>; <pgsql-sql@postgresql.org>
Sent: Monday, April 15, 2002 2:53 PM
Subject: Re: [SQL] data order problem
> Jack,
>
> > 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.
>
> 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.
>
> -Josh Berkus
>