Re: What's wrong with this function

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  egfor 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