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 BFC4D30D1C1 for ; Thu, 12 Jun 2003 12:10:19 +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 54947-08 for ; Thu, 12 Jun 2003 09:10:09 -0300 (ADT) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by svr1.postgresql.org (Postfix) with SMTP id E780730D1B4 for ; Thu, 12 Jun 2003 09:10:07 -0300 (ADT) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Thu Jun 12 14:12:24 2003 +0200 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id OAA24666; Thu, 12 Jun 2003 14:10:06 +0200 (METDST) Message-ID: <3EE86D9D.BF6ECCA4@rodos.fzk.de> Date: Thu, 12 Jun 2003 14:10:06 +0200 From: Christoph Haller X-Mailer: Mozilla 4.77 [en] (X11; U; HP-UX B.10.20 9000/780) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org, dpradier@apartia.fr Subject: Re: How to make a IN without a table... ? Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 7bit X-Archive-Number: 200306/104 X-Sequence-Number: 13862 > > > These values are not taken in a table, but put in directly. > > 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. > I am not sure I'm getting it right. The first statement suggests the data is coming from outside the database. The second suggests it is derived from the database though. And now it sounds like you could use table functions. Can you confirm that? Regards, Christoph