Re: Order By ignoring "-" character

On Thu, Jun 05, 2003 at 11:43:08 -0400,
Dave Wood <postgresql_question(at)attbi(dot)com> wrote:
> I'm having a problem where the ORDER BY clause is not performing as I
> would expect. I created a small set of test data:
>
> If this isn't considered a bug, then could somebody please enlighten me
> as to the proper use of ORDER BY? In other words, how do I get postgres
> to order by using a sort typical of every text sort I've ever seen?
> Once that takes case into consideration and doesn't pick and choose
> which characters it will use for the sort.

It is a locale issue. Order by sorts by the locale ordering. I believe
the fix for this thi requires an initdb, specifying C for the locale.