Re: How to make a IN without a table... ? - Mailing list pgsql-sql

From David Pradier
Subject Re: How to make a IN without a table... ?
Date
Msg-id 20030612122446.GE680@apartia.fr
Whole thread Raw
In response to Re: How to make a IN without a table... ?  (Christoph Haller <ch@rodos.fzk.de>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Ludwig Lim
Date:
Subject: Some Questions
Next
From: Marco Vezzoli
Date:
Subject: Re: multiple index search with postgres7.1.3 on solaris 8