hi,
i'd like to ask if these two pl/pgsql fragmets are always giving same
results:
1)
FOR lr_rec IN SELECT func(table.x, ...) FROM table,... WHERE ... LOOP
END LOOP;
2)
FOR lr_rec IN SELECT * FROM table,... WHERE ... LOOP
li_x := func(lr_rec.x, ...);
END LOOP;
function func has some "side effects", e.g. inserting rows somewhere...
i think that 1) and 2) should be the same but i'd like to make sure..
thanks,
kuba