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

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




pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: How to make a IN without a table... ?
Next
From: David Pradier
Date:
Subject: Re: How to make a IN without a table... ?