Re: SELECT INTO and ON COMMIT

On Wed, May 13, 2015 at 06:05:43PM -0600, Yves Dorfsman wrote:
>
> On Wed, May 13, 2015 at 05:29:36PM -0600, Yves Dorfsman wrote:
> > Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?
>
> On 2015-05-13 17:56, David G. Johnston wrote:
> > ​From the documentation of SELECT INTO
> >
> > "​
> > The PostgreSQL usage of SELECT INTO to represent table creation is historical.
> > It is best to use CREATE TABLE AS for this purpose in new code.
> > ​"​
> >
> > http://www.postgresql.org/docs/9.4/interactive/sql-createtableas.html
> >
> > ​Which effectively means consider the feature deprecated. Especially since
> > CREATE TABLE is standard conforming and SELECT INTO is not.
>
> Ah! This works. Thanks.
>
> Will `SELECT INTO` be deprecated? It is very convenient when writing pgplsql
> functions, to select into a record.

The pl/psql `SELECT INTO` is not related to the SQL SELECT INTO command
--- yeah, confusing, so no, the pl/psql ability is not deprecated.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +