Tom Lane writes:
> the spec contemplates INTO as introducing a list of scalar variables to
> be assigned to. plpgsql and ecpg both use this meaning for SELECT INTO.
>
> Would anyone object if I add text to the SELECT INTO ref page that
> points this out, and recommends CREATE TABLE AS as the preferred
> syntax?
I agree. SELECT INTO is misnamed; it sounds like INSERT ... SELECT.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/