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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
