Skip site navigation (1) Skip section navigation (2)

a problem with data sorting

From: "jack" <datactrl(at)tpg(dot)com(dot)au>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: a problem with data sorting
Date: 2002-04-17 10:08:10
Message-ID: 003a01c1e5f7$c7d6f200$1400a8c0@jac (view raw or flat)
Thread:
Lists: pgadmin-support
Hi,

I 've got a data sorting problem when running PgAdmin II v1.2. Providing
there is simple table, called "test_xx", which has only one column, called
"aa" CHAR(16), and the column is set as primary key. Put in some data such
as following.
( _ stands for a space character)

'AA_B'
'AAB'
'BB_123'
'BB123'

After execute ...

SELECT * FROM test_xx ORDER BY aa;

I 've got ...

'AAB'
'AA_B'
'BB123'
'BB_123'

How can 'AAB' < 'AA_B' and  'BB123' <'BB_123'?

I run it under windows xp. Does it matter?  Thnak you!!

Jack





pgadmin-support by date

Next:From: Dave PageDate: 2002-04-17 18:36:00
Subject: Re: a problem with data sorting
Previous:From: David GriffithsDate: 2002-04-16 16:31:15
Subject: Re: Oracle->Postgres Migration Problems.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group