Re: Sorting Problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tim Edwards" <mor4321(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting Problem
Date: 2003-08-12 22:15:11
Message-ID: 17157.1060726511@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tim Edwards" <mor4321(at)hotmail(dot)com> writes:
> When I sort ASC on the varchar I get some strange results. Here a section of
> data cut after running a sort. It starts with RM- then does RMT- Then goes
> back for more RM-.

Sounds like you're in en_US locale, or at least something other than C
locale.

Unfortunately this can only be fixed by re-initdb'ing :-(

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kathy zhu 2003-08-12 22:30:29 Re: Sorting Problem
Previous Message Tim Edwards 2003-08-12 21:58:40 Sorting Problem