Re: plpgsql execute vs. SELECT ... INTO - Mailing list pgsql-hackers

From Tom Lane
Subject Re: plpgsql execute vs. SELECT ... INTO
Date
Msg-id 3915.1288997646@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql execute vs. SELECT ... INTO  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: plpgsql execute vs. SELECT ... INTO
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> The comment on the commit says:

>     EXECUTE of a SELECT ... INTO now draws a 'not implemented' error,
>     rather than executing the INTO clause with non-plpgsql semantics
>     as it was doing for the last few weeks/months.  This keeps our options
>     open for making it do the right plpgsql-ish thing in future without
>     creating a backwards compatibility problem.  There is no loss of
>     functionality since people can get the same behavior with CREATE TABLE AS.

> Do we really still need to keep out options open on this after all that 
> time?

I think it's still a good idea that it won't do something that is very
much different from what a non-EXECUTE'd SELECT INTO will do.

I forget, is there a HINT there suggesting CREATE TABLE AS?  Maybe we
should add one if not.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: plpgsql execute vs. SELECT ... INTO
Next
From: Andrew Dunstan
Date:
Subject: Re: plpgsql execute vs. SELECT ... INTO