Christophe RIMBAUD ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
incorect sort using order by

Long Description
I have a problem with the order by command.
The column is in CHAR, 
for example :
table WAPI (wapinom CHAR(6));

select wapinom from wapi order by wapinom ;
 wapinom
----------
 ACTI-ACC
 ACTI-CRE
 ACTIGINT
 ACTI-MOD
 ACTI-SUP
 ACTU-CRE
 ACTUGINT
 ACTU-INL

my question : why 'ACTIGINT' is after 'ACTI-CRE'. Under Oracle 'ACTIGINT' is after 
'ACTI-SUP' that's better.
I'm about to transform a big piece of oracle code to postgres and this bug is very 
annoyance for me .

Thanks in advance

Chris


Sample Code


No file was uploaded with this report


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to