X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 6129A30ED64 for ; Mon, 16 Jun 2003 07:28:37 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 59840-06 for ; Mon, 16 Jun 2003 04:28:27 -0300 (ADT) Received: from zenon.apartia.com (ATuileries-107-2-1-69.w217-128.abo.wanadoo.fr [217.128.120.69]) by svr1.postgresql.org (Postfix) with ESMTP id 9257030EC62 for ; Mon, 16 Jun 2003 04:28:26 -0300 (ADT) Received: from argos (argos.apartia.fr [10.0.2.105]) by zenon.apartia.com (Postfix) with ESMTP id C9CBF36A73; Mon, 16 Jun 2003 09:28:25 +0200 (CEST) Received: by argos (Postfix, from userid 1018) id 3B7C79F22; Mon, 16 Jun 2003 09:27:40 +0200 (CEST) Date: Mon, 16 Jun 2003 09:27:40 +0200 From: David Pradier To: "scott.marlowe" Cc: Christoph Haller , pgsql-sql@postgresql.org Subject: Re: How to make a IN without a table... ? Message-ID: <20030616072740.GA658@apartia.fr> Mail-Followup-To: "scott.marlowe" , Christoph Haller , pgsql-sql@postgresql.org References: <20030612115027.GB680@apartia.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i X-Archive-Number: 200306/137 X-Sequence-Number: 13895 > > I avoid as hell to use temporary tables. This is part of a complex > > database, with more than 250 different tables. So i don't even want to > > think about adding temporary tables, brrr ! > > Just FYI, temporary tables in pgsql are invisible to other connections > even if they have the same name, and are auto-dropped when the connection > is dropped. Well, i didn't know this. I will check how it works. Thanks a lot, Scott. -- dpradier@apartia.fr 01.46.47.21.33