Jie Liang wrote:
> I just know you can use implict cursor inside the plpgsql
> e.g
> declare
result text;
tcount int4;
>
> rec record;
> begin
> FOR rec IN select_clause LOOP
> statements
> END LOOP;
> end;
>
Thank you Jie for your help. I am bit confused about how it works. I want for
each row , obtained by select statment, get certain values and then do some
calculations and out put that resulst eg
for rec IN select title, dcount from songs where artist='xyz'
tcount:= tcount+rec.dcount;
END LOOP;
return tcount;
would this work ?
Thanks again for your help.
Regards, Najm