Chamath Sajeewa <csgsajeewa@gmail.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.)