Re: PGSQL returning into in insert statement

Btw oracle support this in plain sql too.

On Thu, 30 Jul 2020, 11:42 Chamath Sajeewa, <csgsajeewa(at)gmail(dot)com> wrote:

> Understood. Thank you!
>
> On Thu, 30 Jul 2020, 08:35 Tom Lane, <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Chamath Sajeewa <csgsajeewa(at)gmail(dot)com> writes:
>> > I want to use "returning into" in insert statement. I tried below,
>>
>> > insert into test_table(key,value) values('key1',5) returning value into
>> > returnvalue;
>>
>> > and below error occurred- syntax error at or near "into".
>>
>> That is perfectly legit syntax within a plpgsql function, but it
>> would produce the mentioned syntax error if you tried to use it
>> directly at the SQL level. So I conclude that you're fuzzy about
>> the difference between SQL and plpgsql. You can use plpgsql
>> statements within plpgsql-language function definitions, and
>> within DO blocks. But not as plain SQL. (Plain SQL has no concept
>> of variables either, so "into returnvalue" makes no sense there
>> anyway.)
>>
>> regards, tom lane
>>
>