Re: PGSQL returning into in insert statement

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
>