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 AECAC30D1B4 for ; Thu, 12 Jun 2003 12:21:46 +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 56129-09 for ; Thu, 12 Jun 2003 09:21:36 -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 B469F30D1BE for ; Thu, 12 Jun 2003 09:21:35 -0300 (ADT) Received: from argos (argos.apartia.fr [10.0.2.105]) by zenon.apartia.com (Postfix) with ESMTP id 6540298D21; Thu, 12 Jun 2003 14:21:35 +0200 (CEST) Received: by argos (Postfix, from userid 1018) id C190ED0A8; Thu, 12 Jun 2003 14:21:33 +0200 (CEST) Date: Thu, 12 Jun 2003 14:21:33 +0200 From: David Pradier To: Christoph Haller , pgsql-sql@postgresql.org Subject: Re: How to make a IN without a table... ? Message-ID: <20030612122133.GD680@apartia.fr> Mail-Followup-To: Christoph Haller , pgsql-sql@postgresql.org References: <3EE8610A.EBE8B77@rodos.fzk.de> <20030612115027.GB680@apartia.fr> <20030612120929.GC1285@wolff.to> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030612120929.GC1285@wolff.to> User-Agent: Mutt/1.5.4i X-Archive-Number: 200306/105 X-Sequence-Number: 13863 On Thu, Jun 12, 2003 at 07:09:29AM -0500, Bruno Wolff III wrote: > On Thu, Jun 12, 2003 at 13:50:27 +0200, > David Pradier wrote: > > > > I guess i wasn't clear enough. > > "my_function" here is a function which calculate some results about some > > datas from the database. > > Example : a function which would calculate the sum of the money (which > > would be stored in the database by movement, ie amount + date + cause + > > account) spent by user my_var1 during period my_var2. > > > > So no, perl can't do this. > > I think the idea was that perl could generate multiple query statements > for you. This would be slower than doing as one query, but if the database > is local there wouldn't be much difference. Hmmm yes... I'll try this too, good idea :-) David -- dpradier@apartia.fr 01.46.47.21.33