Horton
Menu

Re: Re: [GENERAL] Re: temp table creation

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Alfonso Peniche <alfonso@iteso.mx>, PostgreSQL-documentation <pgsql-docs@postgresql.org>
Date: 2001-03-20T18:32:49Z
Lists: pgsql-general 
> 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