PGSQL returning into in insert statement
От
Chamath Sajeewa
Тема
PGSQL returning into in insert statement
Дата
Msg-id
CACpofegcG+Ke2r4yoCpwRKPnV8r+fiGfB1w=ur4M3KHvTFKkpg@mail.gmail.com
Список
Дерево обсуждения
PGSQL returning into in insert statement Chamath Sajeewa <csgsajeewa@gmail.com>
Re: PGSQL returning into in insert statement Tom Lane <tgl@sss.pgh.pa.us>
Re: PGSQL returning into in insert statement Chamath Sajeewa <csgsajeewa@gmail.com>
Re: PGSQL returning into in insert statement Chamath Sajeewa <csgsajeewa@gmail.com>
Re: PGSQL returning into in insert statement Stephen Frost <sfrost@snowman.net>
Hi all,
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".
What is the correct method to use it?
Thanks!
В списке pgsql-novice по дате отправления
