From mboxrd@z Thu Jan 1 00:00:00 1970 Received: by 10.90.87.14 with SMTP id k14cs565641agb; Sat, 19 Dec 2009 11:03:56 -0800 (PST) Received: by 10.224.82.10 with SMTP id z10mr3069913qak.50.1261249435354; Sat, 19 Dec 2009 11:03:55 -0800 (PST) Return-Path: Received: from rubyforge.org (rubyforge.org [205.234.109.19]) by mx.google.com with ESMTP id 27si7101221qyk.55.2009.12.19.11.03.54; Sat, 19 Dec 2009 11:03:55 -0800 (PST) Received-SPF: pass (google.com: domain of sup-talk-bounces@rubyforge.org designates 205.234.109.19 as permitted sender) client-ip=205.234.109.19; Authentication-Results: mx.google.com; spf=pass (google.com: domain of sup-talk-bounces@rubyforge.org designates 205.234.109.19 as permitted sender) smtp.mail=sup-talk-bounces@rubyforge.org Received: from rubyforge.org (rubyforge.org [127.0.0.1]) by rubyforge.org (Postfix) with ESMTP id 69C2E1779938; Sat, 19 Dec 2009 14:03:54 -0500 (EST) X-Greylist: delayed 1201 seconds by postgrey-1.31 at rubyforge.org; Mon, 14 Dec 2009 16:05:38 EST Received: from smtp.webfaction.com (mail6.webfaction.com [74.55.86.74]) by rubyforge.org (Postfix) with ESMTP id 443B018582CE for ; Mon, 14 Dec 2009 16:05:38 -0500 (EST) Received: from localhost (adsl-76-246-132-169.dsl.fyvlar.sbcglobal.net [76.246.132.169]) by smtp.webfaction.com (Postfix) with ESMTP id 41BA71C75EF4 for ; Mon, 14 Dec 2009 14:45:30 -0600 (CST) From: Michael McDermott To: sup-talk In-reply-to: <1260810592-sup-4853@nixos> References: <1260809732-sup-4895@zion> <1260810592-sup-4853@nixos> Date: Mon, 14 Dec 2009 14:45:28 -0600 Message-Id: <1260822912-sup-2952@zion> User-Agent: Sup/0.8.1 X-Mailman-Approved-At: Sat, 19 Dec 2009 14:01:29 -0500 Subject: Re: [sup-talk] Sorting X-BeenThere: sup-talk@rubyforge.org X-Mailman-Version: 2.1.12 Precedence: list List-Id: User & developer discussion of Sup List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Sender: sup-talk-bounces@rubyforge.org Errors-To: sup-talk-bounces@rubyforge.org The thing that brought it to mind was search results. In particular, I was searching for messages with a particular label, then wanting to sort them by date. (I am running sup version 0.8.1, installed from the Jaunty repositories, if that is of any help). At least at my current version, the messages were not in a chronological order. There were messages from the last couple of days interleaved for the first few pages. That said, I am sure that arbitrary sorting would be useful. Heck, even Thunderbird and Outlook (much less powerful though they be) allow messages to be sorted by fields other than date received. Excerpts from Marc Weber's message of Mon Dec 14 11:13:01 -0600 2009: > Excerpts from Michael McDermott's message of Mon Dec 14 18:01:39 +0100 2009: > > After running a search in Sup, is there any way to sort the result set? Or, > > perhaps, specify the ordering in the query? (ala SQL) > > Hi McDermott > > Sup is lazy. > > It only searches as much results as fit on screen unless you use !! > I think threads are sorted by date which makes much sense. > > You propose that you want a ORDER BY feature. > >From SQL you should also know that this forces the database to fetch all > rows even if you're interested only in LIMIT 1. > > So try !! and wait. If it' fast enough tell so. If it's not think about > another way to solve you real problem. Maybe just put your real problem > here. There may be a different solution. > > You want to stort your threads by which field? > > Marc Weber -- Michael McDermott www.mad-computer-scientist.com _______________________________________________ sup-talk mailing list sup-talk@rubyforge.org http://rubyforge.org/mailman/listinfo/sup-talk