biju.geo...@ust-global.com writes: > The following bug has been logged on the website: > Bug reference: 6583 > Logged by: Biju George > Email address: biju.geo...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs