[PATCHES] PLpgSQL: list of scalars as row for assign stmt, fore and fors stms

[Pavel Stehule]

Hello




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/

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

scalarlist.diff
Description: application/binary

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match