Re: SELECT INTO and ON COMMIT

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.

--
http://yves.zioup.com
gpg: 4096R/32B0F416