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

From Andrew Dunstan
Subject plpgsql execute vs. SELECT ... INTO
Date
Msg-id 4CD489FF.1000908@dunslane.net
Whole thread Raw
Responses Re: plpgsql execute vs. SELECT ... INTO
List pgsql-hackers
(Prompted by a puzzled user on IRC)

Ten years ago, nearly, we made this commit 
<https://github.com/postgres/postgres/commit/8a2cdd77ad5c0a4f8902ea86d0377336e076abcb> 
(see what a good thing it is we carefully got all the history 
transferred to git?)

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-plpgsqlsemantics   as it was doing for the last few weeks/months.  This keeps our options   open for making it do
theright plpgsql-ish thing in future without   creating a backwards compatibility problem.  There is no loss of
functionalitysince 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?

cheers

andrew



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Make" versus effective stack limit in regression tests
Next
From: Tom Lane
Date:
Subject: Re: plpgsql execute vs. SELECT ... INTO