X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9BC47D1B9AF for ; Wed, 20 Aug 2003 14:41:21 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 31352-07 for ; Wed, 20 Aug 2003 14:41:11 -0300 (ADT) Received: from megazone.bigpanda.com (45.mufb.snfc.sffca01r18.dsl.att.net [12.103.249.45]) by svr1.postgresql.org (Postfix) with ESMTP id 6AC95D1BABB for ; Wed, 20 Aug 2003 14:41:10 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id B0092D600; Wed, 20 Aug 2003 10:41:09 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 9DA5E5C0C; Wed, 20 Aug 2003 10:41:09 -0700 (PDT) Date: Wed, 20 Aug 2003 10:41:09 -0700 (PDT) From: Stephan Szabo To: Rod Taylor Cc: Mike Winter , Subject: Re: "SELECT IN" Still Broken in 7.4b In-Reply-To: <1061399385.40948.13.camel@jester> Message-ID: <20030820103841.Q10580-100000@megazone.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/232 X-Sequence-Number: 14848 On Wed, 20 Aug 2003, Rod Taylor wrote: > > Thanks, Stephan. I was really hoping that the IN(valuelist) was going to > > be changed at the same time, because it really is unusable for anything > > over a couple of thousand values. > > Changed to do what? One possibility might be to act as if the valuelist was a table and do the IN as if it were that way, rather than treating it as a set of ORs. That would be basically like doing the temporary table solution, but without requiring the user to do it.