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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How to make a IN without a table... ?
Date: 2003-06-12 12:09:29
Message-ID: 20030612120929.GC1285@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Jun 12, 2003 at 13:50:27 +0200,
David Pradier <dpradier(at)apartia(dot)fr> wrote:
>
> 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.
>
> So no, perl can't do this.

I think the idea was that perl could generate multiple query statements
for you. This would be slower than doing as one query, but if the database
is local there wouldn't be much difference.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christoph Haller 2003-06-12 12:10:06 Re: How to make a IN without a table... ?
Previous Message Bruno Wolff III 2003-06-12 12:07:22 Re: multiple index search with postgres7.1.3 on solaris 8