Received: from anchor-post-34.mail.demon.net (anchor-post-34.mail.demon.net [194.217.242.92]) by postgresql.org (Postfix) with ESMTP id 7CDC4475BCB; Mon, 25 Feb 2002 16:33:49 -0500 (EST) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-34.mail.demon.net with esmtp (Exim 3.34 #1) id 16fSko-000Etv-0Y; Mon, 25 Feb 2002 21:33:50 +0000 Received: from localhost ([127.0.0.1] helo=localhost.localdomain ident=olly) by linda.lfix.co.uk with esmtp (Exim 3.34 #1 (Debian)) id 16fRJ8-0000Bs-00; Mon, 25 Feb 2002 20:01:10 +0000 Subject: Re: Sort problem From: Oliver Elphick To: "Samuel J. Sutjiono" Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: <016001c1be20$3d65fed0$110a010a@headquarters.wcgroup.com> References: <016001c1be20$3d65fed0$110a010a@headquarters.wcgroup.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2 Date: 25 Feb 2002 20:01:10 +0000 Message-Id: <1014667270.5761.15.camel@linda> Mime-Version: 1.0 X-Archive-Number: 200202/1236 X-Sequence-Number: 21228 On Mon, 2002-02-25 at 17:17, Samuel J. Sutjiono wrote: > I was trying to do the following sort (two attributes with different types), but I kept on getting errors. > > ORDER BY Price (data type - decimal), ProductName (data type - varchar) There doesn't seem to be anything wrong with that phrase. You need to show us the whole query and the error messages. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "Peace I leave with you, my peace I give unto you; not as the world giveth, give I unto you. Let not your heart be troubled, neither let it be afraid." John 14:27