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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +