Re: [BUGS] BUG #6583: for loop cursor

2012-04-13 Thread Biju George (UST, IND)
y, Biju George UST Global | Trivandrum From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Thu 4/12/2012 8:34 PM To: Biju George (UST, IND) Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6583: for loop cursor I wrote: > Works for me in 8.4.11 (after correcting rec

Re: [BUGS] BUG #6583: for loop cursor

2012-04-12 Thread Tom Lane
I wrote: > 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. Actually, I do get the described behavior when trying this in 8.3, which does not have FOR-over-cursor. So maybe the more appropria

Re: [BUGS] BUG #6583: for loop cursor

2012-04-12 Thread Tom Lane
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 cod

[BUGS] BUG #6583: for loop cursor

2012-04-12 Thread biju . george
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