Received: from qmsql.netservers.net (hpmail3.netservers.net [209.196.128.174]) by postgresql.org (Postfix) with SMTP id B47CF476469 for ; Mon, 25 Feb 2002 14:57:36 -0500 (EST) Received: (qmail 24323 invoked from network); 25 Feb 2002 19:57:32 -0000 Received: from unknown (HELO AARON) (66.26.63.73) by hpmail3.netservers.net with SMTP; 25 Feb 2002 19:57:31 -0000 Message-ID: <024901c1be36$04f87df0$110a010a@headquarters.wcgroup.com> From: "Samuel J. Sutjiono" To: "Bruce Momjian" Cc: , References: <200202251946.g1PJkbn04775@candle.pha.pa.us> Subject: Re: [SQL] Sort problem Date: Mon, 25 Feb 2002 14:52:55 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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/1224 X-Sequence-Number: 21216 Bruce, My apology. Actually I posted the wrong problem. Here is my problem: IF (SortOrder = ''price'') Then BEGIN For rec_set IN SELECT * from Catalog where ((VendorName ~* SearchString) ORDER BY CASE WHEN SortOrder = ''store'' Then VendorName WHEN SortOrder = ''category'' Then ProductCategory Else Price END Here is the error message: ERROR: CASE types "numeric" and "varchar" not matched. By the way, do you know how to do a variable (that contains 'attribute name' instead of 'attribute value') substitution. For instance, if the attribute name 'Price' is passed to the sort parameter ($1) so I can just do ORDER BY $1 instead of doing case statement. Thanks so much for your help. Sam ----- Original Message ----- From: "Bruce Momjian" To: "Samuel J. Sutjiono" Cc: ; Sent: Monday, February 25, 2002 2:46 PM Subject: Re: [SQL] Sort problem > 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) > > Would you share the errors with us? :-) > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 >