PLpgSQL: list of scalars as row for assign stmt, fore and fors stms - Mailing list pgsql-patches

Hello

This patch enhance possibilities fore, fors, assign statements and remove
not needed using row or record variable.

create function a(out x integer, out y integer) returns setof record as $$
declare r record;
begin
  for x, y in select form data loop
    return next;
  end loop;
  -- or --
  for r in select * from data loop
    x, y := r;
    return next;
  end loop;
  return;
end; $$ language plpgsql;

This patch allow using qualified identifiers in fore and fors stmts too.

Best regards
Pavel Stehule

_________________________________________________________________
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/