pgsql-bugs(at)postgresql(dot)org 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