> can i declare and fetch from a cursor inside a
plpgsql function? (pg version 7.0.3)
In 7.1, the pl/pgsql document says you can code like
this:
DECLARE
rec record;
BEGIN
for rec in SELECT * from MyTable LOOP
update tableX set tableX=rec.fieldA;
END LOOP;
END;
CN
--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com