Re: Re: [GENERAL] Re: temp table creation - Mailing list pgsql-docs

From Peter Eisentraut
Subject Re: Re: [GENERAL] Re: temp table creation
Date
Msg-id Pine.LNX.4.30.0103201901390.1639-100000@peter.localdomain
Whole thread Raw
In response to Re: Re: [GENERAL] Re: temp table creation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: [GENERAL] Re: temp table creation
List pgsql-docs
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/


pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [GENERAL] Re: temp table creation
Next
From: Bruce Momjian
Date:
Subject: Re: Re: [GENERAL] Re: temp table creation