From: David Pradier <dpradier@apartia.fr>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: How to make a IN without a table... ?
Date: Thu, 12 Jun 2003 14:24:46 +0200
Message-ID: <20030612122446.GE680@apartia.fr> (raw)
In-Reply-To: <3EE86D9D.BF6ECCA4@rodos.fzk.de>
References: <3EE86D9D.BF6ECCA4@rodos.fzk.de>
On Thu, Jun 12, 2003 at 02:10:06PM +0200, Christoph Haller wrote:
> > > > 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
The arguments of the functions come from outside the database, but the
function itself uses the datas in the database.
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 ? :-)
What do you mean by table function ?
Regards, David
--
dpradier@apartia.fr 01.46.47.21.33
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dpradier@apartia.fr, ch@rodos.fzk.de
Subject: Re: How to make a IN without a table... ?
In-Reply-To: <20030612122446.GE680@apartia.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox