Re: Sorting Issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Samuel Gendler <sgendler(at)ideasculptor(dot)com>
Cc: emilu(at)encs(dot)concordia(dot)ca, "Ozer, Pam" <pozer(at)automotive(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Sorting Issue
Date: 2011-05-09 21:28:34
Message-ID: 4547.1304976514@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Samuel Gendler <sgendler(at)ideasculptor(dot)com> writes:
> It's not at all clear why they are not coming out of the db in
> alphabetically sorted order when the query includes "order by
> VehicleTrimAbbreviated asc"

Usually the thing to ask at this point is "what's the database's
LC_COLLATE setting"? Non-C locales often have truly bizarre
sorting rules.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ozer, Pam 2011-05-09 22:13:07 Re: Sorting Issue
Previous Message Samuel Gendler 2011-05-09 21:08:41 Re: Sorting Issue