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 6242730DFDC for ; Thu, 12 Jun 2003 12:49:29 +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 63752-01 for ; Thu, 12 Jun 2003 09:49:19 -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 A34B430D1A7 for ; Thu, 12 Jun 2003 09:49:18 -0300 (ADT) Received: from argos (argos.apartia.fr [10.0.2.105]) by zenon.apartia.com (Postfix) with ESMTP id C4CFD9A5A0; Thu, 12 Jun 2003 14:49:18 +0200 (CEST) Received: by argos (Postfix, from userid 1018) id 0D9C4DDC4; Thu, 12 Jun 2003 14:49:17 +0200 (CEST) Date: Thu, 12 Jun 2003 14:49:17 +0200 From: David Pradier To: Christoph Haller Cc: pgsql-sql@postgresql.org Subject: Re: How to make a IN without a table... ? Message-ID: <20030612124916.GH680@apartia.fr> Mail-Followup-To: Christoph Haller , pgsql-sql@postgresql.org References: <3EE873EB.9C713F4E@rodos.fzk.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3EE873EB.9C713F4E@rodos.fzk.de> User-Agent: Mutt/1.5.4i X-Archive-Number: 200306/110 X-Sequence-Number: 13868 On Thu, Jun 12, 2003 at 02:37:00PM +0200, Christoph Haller wrote: > > > > Like "Tell me how much i spent between the 4th and the 7th og this > month > > ?" uses 4 and 7 as arguments, but need to fetch the datas in the > > database. > > Clear enough ? :-) > Yes. > > > > What do you mean by table function ? > > Table functions are aka SetReturningFunctions. > Refer to > http://techdocs.postgresql.org/guides/SetReturningFunctions Very interesting, i'll dig into it. Thanks a lot, Christoph. -- dpradier@apartia.fr 01.46.47.21.33