Re: Sorting Issue - Mailing list pgsql-sql

From Tom Lane
Subject Re: Sorting Issue
Date
Msg-id 4547.1304976514@sss.pgh.pa.us
Whole thread Raw
In response to Re: Sorting Issue  (Samuel Gendler <sgendler@ideasculptor.com>)
Responses Re: Sorting Issue  ("Ozer, Pam" <pozer@automotive.com>)
List pgsql-sql
Samuel Gendler <sgendler@ideasculptor.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


pgsql-sql by date:

Previous
From: Samuel Gendler
Date:
Subject: Re: Sorting Issue
Next
From: "Ozer, Pam"
Date:
Subject: Re: Sorting Issue