cannot use result of (insert .. returning) - Mailing list pgsql-ru-general

From dvs
Subject cannot use result of (insert .. returning)
Date
Msg-id 01ae01c8c153$3b40fbe0$0e09a8c0@dvs
Whole thread Raw
List pgsql-ru-general
Hello,

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

Is this a bug?

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

any ideas?

dvs


pgsql-ru-general by date:

Previous
From: "pronix pronix"
Date:
Subject: ограничение пользователя постгреса
Next
From: apm
Date:
Subject: Не используется индекс в запросе.