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 по дате отправления
От: Markus Schiltknecht
Дата: