Re: Sorting Issue

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

I was wrong it is



LC_COLLATE = 'en_US.utf8'

-----Original Message-----
From: Ozer, Pam
Sent: Monday, May 09, 2011 3:13 PM
To: 'Tom Lane'; Samuel Gendler
Cc: emilu(at)encs(dot)concordia(dot)ca; pgsql-sql(at)postgresql(dot)org
Subject: RE: [SQL] Sorting Issue

The collate setting is
LC_COLLATE = 'English_United States.1252'

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, May 09, 2011 2:29 PM
To: Samuel Gendler
Cc: emilu(at)encs(dot)concordia(dot)ca; Ozer, Pam; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Sorting Issue

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-10 15:26:27 Re: Sorting Issue
Previous Message fpirotti 2011-05-10 11:49:04 view table with foreign key relative values