Re: [BUGS] Bug #577: incorect sort using order by

2002-02-08 Thread Tom Lane
[EMAIL PROTECTED] writes: > my question : why 'ACTIGINT' is after 'ACTI-CRE'. Under Oracle > 'ACTIGINT' is after 'ACTI-SUP' that's better. If you think that, you should be using C locale not whatever you are using (perhaps en-US locale). Postgres sorts according to the rules of the locale that t

[BUGS] Bug #577: incorect sort using order by

2002-02-07 Thread pgsql-bugs
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)); s