Thread: upgrading to postgresql 8

when i upgraded from 7.4 to 8 many of my functions no loger worked,
they all had something in common:
DECLARE
  produto  RECORD;
BEGIN
  FOR producto IN SELECT producto FROM p LOOP

the error reported was: record "producto" is not assigned yet

i finally realized that name of the variable can no longer be the same
as the name of a column in the select statement.

i guess i will just have to re-write all my functions or is there way
around this?

javier

guegue <guegue@gmail.com> writes:
> i finally realized that name of the variable can no longer be the same
> as the name of a column in the select statement.

That generally didn't work before, either.  I think it might have
accidentally failed to not work for record/rowtype variables, but those
are now treated much like other variables.

            regards, tom lane