X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9D1BA32A0D8 for ; Tue, 19 Oct 2004 16:47:25 +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 40473-02 for ; Tue, 19 Oct 2004 15:47:22 +0000 (GMT) Received: from smtp100.rog.mail.re2.yahoo.com (smtp100.rog.mail.re2.yahoo.com [206.190.36.78]) by svr1.postgresql.org (Postfix) with SMTP id 1D86B32A2A7 for ; Tue, 19 Oct 2004 16:47:20 +0100 (BST) Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@65.49.125.184 with login) by smtp100.rog.mail.re2.yahoo.com with SMTP; 19 Oct 2004 15:47:19 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 541F04058; Tue, 19 Oct 2004 11:47:18 -0400 (EDT) Date: Tue, 19 Oct 2004 11:47:18 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Why isn't this index being used? Message-ID: <20041019154718.GG3359@phlogiston.dyndns.org> Mail-Followup-To: pgsql-performance@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6+20040722i 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/277 X-Sequence-Number: 8753 On Tue, Oct 19, 2004 at 11:33:50AM -0400, Knutsen, Mark wrote: > (Why don't replies automatically go to the list?) Because sometimes you don't want them to. There's been dozens of discussions about this. BTW, mutt has a nice feature which allows you to reply to lists -- I imagine other MUAs have such a feature too. > Sure enough, quoting the constants fixes the problem. > > Is it a best practice to always quote constants? No, but it's very useful in these cases. The problem is I believe this is fixed in 8.0, BTW. See the FAQ, question 4.8 A -- Andrew Sullivan | ajs@crankycanuck.ca I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin