From: jack <datactrl@tpg.com.au>
To: pgsql-sql@postgresql.org
To: Josh Berkus <josh@agliodbs.com>
Subject: Re: data order problem
Date: Mon, 15 Apr 2002 16:40:03 +1000
Message-ID: <001301c1e448$609a7cc0$1400a8c0@jac> (raw)
References: <web-1370236@davinci.ethosmedia.com>
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
>
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, josh@agliodbs.com
Subject: Re: data order problem
In-Reply-To: <001301c1e448$609a7cc0$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