Sorting Issue - Mailing list pgsql-sql

<div class="WordSection1"><p class="MsoNormal">I have the following query<p class="MsoNormal">Select
 VehicleTrimAbbreviated,VehicleTrimAbbreviatedId<p class="MsoNormal">from VehicleTrimAbbreviated<p
class="MsoNormal">WherevehicleTrimAbbreviated like 'CX%'<p class="MsoNormal">order by VehicleTrimAbbreviated asc<p
class="MsoNormal"> <pclass="MsoNormal"> <p class="MsoNormal">Results:<p class="MsoNormal">532;"CX Hatchback"<p
class="MsoNormal">536;"CXLMinivan"<p class="MsoNormal">3255;"CXL Premium Sedan"<p class="MsoNormal">537;"CXL Sedan"<p
class="MsoNormal">538;"CXLSport Utility"<p class="MsoNormal">3319;"CXL Turbo Sedan"<p class="MsoNormal">533;"CX
Minivan"<pclass="MsoNormal">1959;"CX Plus Minivan"<p class="MsoNormal">534;"CX Sedan"<p class="MsoNormal">535;"CX Sport
Utility"<pclass="MsoNormal">539;"CXS Sedan"<p class="MsoNormal"> <p class="MsoNormal">Why would this not sort
correctly? All the CX should be first, then CXL, Then CXS<p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">Here is the table definition:<p class="MsoNormal"> <p class="MsoNormal">CREATE
TABLEvehicletrimabbreviated<p class="MsoNormal">(<p class="MsoNormal">  vehicletrimabbreviatedid integer NOT NULL,<p
class="MsoNormal"> vehicletrimabbreviated character varying(64),<p class="MsoNormal">  vehiclesubmodelid integer,<p
class="MsoNormal"> vehiclebodystyleid smallint,<p class="MsoNormal">  vehiclebodystylegroupid smallint<p
class="MsoNormal">)<pclass="MsoNormal">WITH (<p class="MsoNormal">  OIDS=FALSE<p class="MsoNormal">);<p
class="MsoNormal">ALTERTABLE vehicletrimabbreviated OWNER TO app_user;<p class="MsoNormal"> <p class="MsoNormal">--
Index:vehicletrimabbreviated_i00<p class="MsoNormal"> <p class="MsoNormal">-- DROP INDEX vehicletrimabbreviated_i00;<p
class="MsoNormal"> <pclass="MsoNormal">CREATE UNIQUE INDEX vehicletrimabbreviated_i00<p class="MsoNormal">  ON
vehicletrimabbreviated<pclass="MsoNormal">  USING btree<p class="MsoNormal">  (vehicletrimabbreviatedid);<p
class="MsoNormal"> <pclass="MsoNormal">-- Index: vehicletrimabbreviated_i01<p class="MsoNormal"> <p
class="MsoNormal">--DROP INDEX vehicletrimabbreviated_i01;<p class="MsoNormal"> <p class="MsoNormal">CREATE INDEX
vehicletrimabbreviated_i01<pclass="MsoNormal">  ON vehicletrimabbreviated<p class="MsoNormal">  USING btree<p
class="MsoNormal"> (lower(vehicletrimabbreviated::text));<p class="MsoNormal"> <p class="MsoNormal">-- Index:
vehicletrimabbreviated_i02<pclass="MsoNormal"> <p class="MsoNormal">-- DROP INDEX vehicletrimabbreviated_i02;<p
class="MsoNormal"> <pclass="MsoNormal">CREATE INDEX vehicletrimabbreviated_i02<p class="MsoNormal">  ON
vehicletrimabbreviated<pclass="MsoNormal">  USING btree<p class="MsoNormal">  (vehiclesubmodelid,
vehiclebodystyleid);<pclass="MsoNormal"> <p class="MsoNormal">-- Index: vehicletrimabbreviated_i03<p
class="MsoNormal"> <pclass="MsoNormal">-- DROP INDEX vehicletrimabbreviated_i03;<p class="MsoNormal"> <p
class="MsoNormal">CREATEINDEX vehicletrimabbreviated_i03<p class="MsoNormal">  ON vehicletrimabbreviated<p
class="MsoNormal"> USING btree<p class="MsoNormal">  (vehiclebodystyleid);<p class="MsoNormal"> <p class="MsoNormal">--
Index:vehicletrimabbreviated_i04<p class="MsoNormal"> <p class="MsoNormal">-- DROP INDEX vehicletrimabbreviated_i04;<p
class="MsoNormal"> <pclass="MsoNormal">CREATE INDEX vehicletrimabbreviated_i04<p class="MsoNormal">  ON
vehicletrimabbreviated<pclass="MsoNormal">  USING btree<p class="MsoNormal">  (vehiclebodystylegroupid,
vehiclesubmodelid,vehiclebodystyleid);<p class="MsoNormal"> <p class="MsoNormal">-- Index: vehicletrimabbreviated_i05<p
class="MsoNormal"> <pclass="MsoNormal">-- DROP INDEX vehicletrimabbreviated_i05;<p class="MsoNormal"> <p
class="MsoNormal">CREATEINDEX vehicletrimabbreviated_i05<p class="MsoNormal">  ON vehicletrimabbreviated<p
class="MsoNormal"> USING btree<p class="MsoNormal">  (lower(vehicletrimabbreviated::text), vehiclesubmodelid);<p
class="MsoNormal"> <pclass="MsoNormal">-- Index: vehicletrimabbreviated_i06<p class="MsoNormal"> <p
class="MsoNormal">--DROP INDEX vehicletrimabbreviated_i06;<p class="MsoNormal"> <p class="MsoNormal">CREATE INDEX
vehicletrimabbreviated_i06<pclass="MsoNormal">  ON vehicletrimabbreviated<p class="MsoNormal">  USING btree<p
class="MsoNormal"> (vehiclesubmodelid, vehiclebodystyleid);<p class="MsoNormal"> <div id="content"><p
class="MsoNormal"><b><spanstyle="font-size:11.5pt;font-family:"Arial","sans-serif";color:black">Pam Ozer</span></b><p
class="MsoNormal"><i><spanstyle="font-size:10.5pt;font-family:"Arial","sans-serif";color:black">Data
Architect</span></i><pclass="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"><a
href="mailto:pozer@automotive.com"><spanstyle="color:blue">pozer@automotive.com</span></a> </span><table border="0"
cellpadding="0"class="MsoNormalTable"><tr><td style="padding:0in 0in 0in 0in"><p class="MsoNormal"><b><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black">tel.</span></b><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black">949.705.3468</span></td></tr></table></div><table
border="0"cellpadding="0" cellspacing="0" class="MsoNormalTable" style="width:100.0%" width="100%"><tr
style="height:39.0pt"><tdstyle="width:79.5pt;padding:0in 0in 0in 0in;height:39.0pt" width="106"><p align="center"
class="MsoNormal"style="text-align:center"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"><imgalt="Source Interlink Media logo" border="0"
height="52"id="_x0000_i1026" src="cid:image001.jpg@01CC0E2B.02393D30" width="106" /></span><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"></span></td><tdstyle="width:3.75pt;padding:7.5pt
7.5pt7.5pt 7.5pt;height:39.0pt" width="5"><p align="center" class="MsoNormal" style="text-align:center"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"><imgalt="vertical line" border="0" height="50"
id="_x0000_i1025"src="cid:image002.jpg@01CC0E2B.02393D30" width="1" /></span><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"></span></td><tdstyle="padding:0in 0in 0in
0in;height:39.0pt"><pclass="MsoNormal"><b><i><span
style="font-size:10.5pt;font-family:"Arial","sans-serif";color:black">SourceInterlink Media</span></i></b><p
class="MsoNormal"><spanstyle="font-size:9.0pt;font-family:"Arial","sans-serif";color:black">1733 Alton Pkwy Suite 100,
Irvine,CA 92606</span><p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:black"><ahref="http://www.simautomotive.com"><span
style="color:blue">www.simautomotive.com</span></a></span></td></tr></table><div id="confid_notice"
style="border:none;border-top:solid#D4D4D4 1.0pt;padding:8.0pt 0in 0in 0in"><p class="MsoNormal"><i><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#CDCDCD">ConfidentialityNotice- This electronic
communication,and all information herein, including files attached hereto, is private, and is the property of the
sender.This communication is intended only for the use of the individual or entity named above. If you are not the
intendedrecipient, you are hereby notified that any disclosure of; dissemination of; distribution of; copying of; or,
takingany action in reliance upon this communication, is strictly prohibited. If you have received this communication
inerror, please immediately notify us by telephone, (949)-705-3000, and destroy all copies of this communication. Thank
you.</span></i></div><pclass="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><br /><br
/></span></div>