Re: Bug #577: incorect sort using order by - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #577: incorect sort using order by
Date
Msg-id 23838.1013184590@sss.pgh.pa.us
Whole thread Raw
In response to Bug #577: incorect sort using order by  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: Luis Amigo
Date:
Subject: Re: Bug #576: Can not compile IRIX + GCC
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: [CYGWIN] resource leak in 7.2