Re: BUG #6583: for loop cursor - Mailing list pgsql-bugs

biju.george@ust-global.com writes:
> The following bug has been logged on the website:
> Bug reference:      6583
> Logged by:          Biju George
> Email address:      biju.george@ust-global.com
> PostgreSQL version: 8.4.0
> Operating system:   Linux
> Description:

> Just this simple code throws below error --
> CREATE OR REPLACE FUNCTION my_temp_func(v_acc_type integer)
>   RETURNS void AS
> $BODY$
> declare
> v_cur cursor (acc_num integer) is select pid from public.my_trade_table
> where acc_type = acc_num;
> begin
> for record_var in v_cur(v_acc_type) loop
> raise notice 'ID is %',record_var.id;
> end loop;
> end;
> $BODY$
>   LANGUAGE plpgsql;

Works for me in 8.4.11 (after correcting record_var.id -> record_var.pid
at line 6).  Maybe you need to update to some more recent version than
8.4.0.

            regards, tom lane