Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...' - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'
Date
Msg-id 19715.1278687216@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'  ("David Schmitt" <david@dasz.at>)
Responses Re: BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'
List pgsql-bugs
Tree view 
"David Schmitt" <david@dasz.at> 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 during variable initialization.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "David Schmitt"
Date:
Subject: BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade issues