Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 066F31337BA8
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 10 May 2011 14:11:15 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 39312-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 10 May 2011 17:11:07 +0000 (UTC)
X-Greylist: delayed 00:14:01.191516 by SQLgrey-1.7.6
Received: from smtp.comsquared.com (smtp.comsquared.com [209.155.237.140])
	by mail.postgresql.org (Postfix) with ESMTP id 516281337B96
	for <pgsql-sql@postgresql.org>; Tue, 10 May 2011 14:11:07 -0300 (ADT)
Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1])
	by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id
	p4AGv1Y9013551
	for <pgsql-sql@postgresql.org>; Tue, 10 May 2011 12:57:04 -0400 (EDT)
Received: from erouse052008 ([10.82.60.61])
	by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id
	p4AGv0Fi021090
	for <pgsql-sql@postgresql.org>; Tue, 10 May 2011 12:57:00 -0400 (EDT)
From: "Edward W. Rouse" <erouse@comsquared.com>
To: <pgsql-sql@postgresql.org>
References: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D14F85F1@mail-001.corp.automotive.com>
	<4DC84284.4000903@encs.concordia.ca>
	<216FFB77CBFAEE4B8EE4DF0A939FF1D14F85F7@mail-001.corp.automotive.com>
In-Reply-To: 
 <216FFB77CBFAEE4B8EE4DF0A939FF1D14F85F7@mail-001.corp.automotive.com>
Subject: Re: Sorting Issue
Date: Tue, 10 May 2011 12:57:01 -0400
Message-ID: <064c01cc0f33$48216a80$d8643f80$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcwOgJBkHYVQehm0T5i/ECfN9T2+HgAACT1QACyQIGA=
Content-Language: en-us
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.79 tagged_above=-5 required=5 tests=BAYES_50=0.8,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201105/64
X-Sequence-Number: 35348

Looks like the sort is removing the spaces before sorting.

cxh
cxlm
cxlp
etc...

Edward W. Rouse


-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Ozer, Pam
Sent: Monday, May 09, 2011 3:39 PM
To: emilu@encs.concordia.ca
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Sorting Issue

That works. Why?

-----Original Message-----
From: Emi Lu [mailto:emilu@encs.concordia.ca] 
Sent: Monday, May 09, 2011 12:38 PM
To: Ozer, Pam
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Sorting Issue

> I have the following query
>
> Select VehicleTrimAbbreviated, VehicleTrimAbbreviatedId
>
> from VehicleTrimAbbreviated
>
> Where vehicleTrimAbbreviated like 'CX%'
>
> order by VehicleTrimAbbreviated asc
>
> Results:
>
> 532;"CX Hatchback"
>
> 536;"CXL Minivan"
>
> 3255;"CXL Premium Sedan"
>
> 537;"CXL Sedan"
>
> 538;"CXL Sport Utility"
>
> 3319;"CXL Turbo Sedan"
>
> 533;"CX Minivan"
>
> 1959;"CX Plus Minivan"
>
> 534;"CX Sedan"
>
> 535;"CX Sport Utility"
>
> 539;"CXS Sedan"
>
> Why would this not sort correctly? All the CX should be first, then
CXL,
> Then CXS

Would you mind try:

Select VehicleTrimAbbreviated, VehicleTrimAbbreviatedId
from VehicleTrimAbbreviated
Where vehicleTrimAbbreviated like 'CX%'
order by

split_part(VehicleTrimAbbreviated, ' ', 1) asc,
split_part(VehicleTrimAbbreviated, ' ', 2) asc;



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql