I have two tables A and B, I defined a function f() on A. The problem is
to process the rows in A whose id has appeared in Table B. To save
time, I want to to run function f() on only records that appeared in B.
I tried this:
define f(integer) as
process records where id in $1
$$ language sql
then I tried to call the function using f(select array_agg(id) from B).
It does not work.
Do you guys know how I can achieve this?
pgsql-novice by date
|Next:||From: Rob Richardson||Date: 2012-03-23 18:06:29|
|Subject: Re: Define a function that accepts query result as a
|Previous:||From: sreeaurovindh viswanathan||Date: 2012-03-23 03:29:41|
|Subject: how to leverage index for order by|