X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A5DAD32A641 for ; Fri, 1 Oct 2004 21:25:33 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44739-09 for ; Fri, 1 Oct 2004 20:25:29 +0000 (GMT) Received: from threadless.com (threadless.com [64.207.133.36]) by svr1.postgresql.org (Postfix) with ESMTP id 9488332A639 for ; Fri, 1 Oct 2004 21:25:29 +0100 (BST) Received: from shanepc (h-64-105-237-58.chcgilgm.covad.net [64.105.237.58]) (authenticated bits=0) by threadless.com (8.12.8/8.12.5) with ESMTP id i91LYQfi025070 for ; Fri, 1 Oct 2004 14:34:26 -0700 Message-ID: <00ab01c4a7f4$f04fffd0$3402a8c0@shanepc> From: "Shane | SkinnyCorp" To: "PgSQL ADMIN" Subject: Re: PLEASE GOD HELP US! Date: Fri, 1 Oct 2004 15:26:31 -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 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/29 X-Sequence-Number: 15023 Okay, just so no one posts about this again... the 'ORDER BY t.status=5,lastreply' clause is meant to float the threads with a status of '5' to the top of the list... it is NOT meant to only grab threads where the status = 5. Oh and believe me, when I take this out of the query, it CERTAINLY doesn't add any more than possible 1/4 of a millesecond to the speed of the SELECT statement. :/