Received: from qmsql.netservers.net (hpmail3.netservers.net [209.196.128.174]) by postgresql.org (Postfix) with SMTP id 2994947685F for ; Mon, 25 Feb 2002 12:21:37 -0500 (EST) Received: (qmail 96694 invoked from network); 25 Feb 2002 17:21:37 -0000 Received: from unknown (HELO AARON) (66.26.63.73) by hpmail3.netservers.net with SMTP; 25 Feb 2002 17:21:37 -0000 Message-ID: <016001c1be20$3d65fed0$110a010a@headquarters.wcgroup.com> From: "Samuel J. Sutjiono" To: , Subject: Sort problem Date: Mon, 25 Feb 2002 12:17:01 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_015D_01C1BDF6.53EF9820" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200202/1218 X-Sequence-Number: 21210 This is a multi-part message in MIME format. ------=_NextPart_000_015D_01C1BDF6.53EF9820 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I was trying to do the following sort (two attributes with different types)= , but I kept on getting errors.=20 ORDER BY Price (data type - decimal), ProductName (data type - varchar) Thanks for any help. ------=_NextPart_000_015D_01C1BDF6.53EF9820 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I was trying to do the following sort (two= =20 attributes with different types), but I kept on getting=20 errors. 
 
ORDER BY Price (data type - decimal), Prod= uctName=20 (data type - varchar)
 
Thanks for any help.
 
 
------=_NextPart_000_015D_01C1BDF6.53EF9820--