Horton
Menu

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

Peter Eisentraut <peter_e@gmx.net>

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

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/