[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 the database was initialized in. Unfortunately, you'll have to re-initdb to change the locale setting. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly