cannot use result of (insert..returning)

Поиск
Список
Период
Сортировка
Искать
От
dvs
Тема
cannot use result of (insert..returning)
Дата
Msg-id
006e01c8c603$5ca703b0$0e09a8c0@dvs
Список
Дерево обсуждения
cannot use result of (insert..returning) "dvs" <dvs@fon.kamchatka.ru>
Re: cannot use result of (insert..returning) "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: cannot use result of (insert..returning) Bruce Momjian <bruce@momjian.us>
Re: cannot use result of (insert..returning) Andrew Dunstan <andrew@dunslane.net>
Re: cannot use result of (insert..returning) Bruce Momjian <bruce@momjian.us>
Hello,

I need to use query like:   select (insert into test (a) values (x) returning b),c from anytable 
where condition
but it say   ERROR: syntax error at or near "into"

Is this a bug?

Function does not work too: create function addt(..) returning .. as 'insert ... returning ..' 
language 'sql'
ERROR:...
DETAIL: Function's final statement must be a SELECT.

BUT:  create function addt(..) returning .. as 
'insert...(nextval(..)...);select currval(..)' language 'sql'
work in   select addt(x),c from anytable where condition

but this function is analog of "insert...returning" in any case
Why analog work "better" then original?
What is my mistake? (I dont want use functions here!)

dvs

В списке pgsql-hackers по дате отправления
От: Martijn van Oosterhout
Дата:
От: Markus Schiltknecht
Дата:
FAQ