a problem with data sorting - Mailing list pgadmin-support

From jack
Subject a problem with data sorting
Date
Msg-id 003a01c1e5f7$c7d6f200$1400a8c0@jac
Whole thread Raw
List 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:

Previous
From: David Griffiths
Date:
Subject: Re: Oracle->Postgres Migration Problems.
Next
From: Dave Page
Date:
Subject: Re: a problem with data sorting