From: | "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org, neilc(at)samurai(dot)com |
Subject: | PLpgSQL: list of scalars as row for assign stmt, fore and fors stms |
Date: | 2005-12-20 08:54:19 |
Message-ID: | BAY20-F18BC52464588DA4C0C6861F93E0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
Attachment | Content-Type | Size |
---|---|---|
scalarlist.diff | application/binary | 11.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-12-20 17:08:05 | Re: PLpgSQL: list of scalars as row for assign stmt, fore and fors stms |
Previous Message | Albert Chin | 2005-12-19 23:41:28 | Re: Trouble building 8.1.1 on Tru64 UNIX 5.1 |