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

From Bruce Momjian
Subject Re: Re: [GENERAL] Re: temp table creation
Date
Msg-id 200103201832.NAA06604@candle.pha.pa.us
Whole thread Raw
In response to Re: Re: [GENERAL] Re: temp table creation  (Peter Eisentraut <peter_e@gmx.net>)
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.

Yes.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Re: [GENERAL] Re: temp table creation
Next
From: Alfonso Peniche
Date:
Subject: Re: [GENERAL] Re: temp table creation