Re: How to make a IN without a table... ?

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org, dpradier(at)apartia(dot)fr
Subject: Re: How to make a IN without a table... ?
Date: 2003-06-12 12:10:06
Message-ID: 3EE86D9D.BF6ECCA4@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ludwig Lim 2003-06-12 12:18:35 Some Questions
Previous Message Bruno Wolff III 2003-06-12 12:09:29 Re: How to make a IN without a table... ?