Re: [BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-12 Thread David Schmitt
On 7/9/2010 4:53 PM, Tom Lane wrote: "David Schmitt" writes: This is not implemented: DECLARE working_cursor NO SCROLL CURSOR FOR EXECUTE $$SELECT something $$ || tbl || $$ ... $$; What's wrong with OPEN FOR EXECUTE? The proposed addition seems a bit weird anyway since it presumes no

Re: [BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-09 Thread Tom Lane
"David Schmitt" writes: > This is not implemented: > DECLARE > working_cursor NO SCROLL CURSOR FOR EXECUTE $$SELECT something $$ || tbl > || $$ ... $$; What's wrong with OPEN FOR EXECUTE? The proposed addition seems a bit weird anyway since it presumes nontrivial calculation to be done duri

[BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-09 Thread David Schmitt
The following bug has been logged online: Bug reference: 5549 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8 and 9 Operating system: n/a Description:Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...' Details: This is not impl