Re: SELECT INTO and ON COMMIT - Mailing list pgsql-general

From Tom Lane
Subject Re: SELECT INTO and ON COMMIT
Date
Msg-id 12795.1431564847@sss.pgh.pa.us
Whole thread Raw
In response to Re: SELECT INTO and ON COMMIT  (Bruce Momjian <bruce@momjian.us>)
Responses Re: SELECT INTO and ON COMMIT
List pgsql-general
Bruce Momjian <bruce@momjian.us> writes:
> On Wed, May 13, 2015 at 06:05:43PM -0600, Yves Dorfsman wrote:
>> 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.

Part of the argument for deprecating the SQL-level SELECT INTO is
exactly that it's confusingly spelled the same as plpgsql's SELECT INTO,
but it means something totally different.

            regards, tom lane


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SELECT INTO and ON COMMIT
Next
From: Melvin Davidson
Date:
Subject: Re: SELECT INTO and ON COMMIT