INSERT doc discrepancy
| От | Kristo Kaiv |
|---|---|
| Тема | INSERT doc discrepancy |
| Дата | |
| Msg-id | 2F77DB50-6007-4CB4-9C78-6945B8BAF5D5@skype.net обсуждение исходный текст |
| Ответы |
Re: INSERT doc discrepancy
|
| Список | pgsql-general |
INSERT INTO table [ ( column [, ...] ) ]
{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
[ RETURNING * | output_expression [ AS output_name ] [, ...] ]
but it seems if i want to return the result into a record i have to use it with INTO clause in the end:
INSERT INTO tablename (
a
,b
,c
) VALUES (
in_a
,in_b
,in_c
) RETURNING * INTO _r;
using either
INSERT INTO tablename (
a
,b
,c
) VALUES (
in_a
,in_b
,in_c
) RETURNING _r;
or
INSERT INTO tablename (
a
,b
,c
) VALUES (
in_a
,in_b
,in_c
) RETURNING * AS _r;
didn't work on PostgreSQL 8.2.4
Kristo Kaiv
http://kaiv.wordpress.com (PostgreSQL blog)
В списке pgsql-general по дате отправления: