cannot use result of (insert .. returning)

From: "dvs" <dvs(at)fon(dot)kamchatka(dot)ru>
To: <pgsql-ru-general(at)postgresql(dot)org>
Subject: cannot use result of (insert .. returning)
Date: 2008-05-29 06:14:19
Message-ID: 01ae01c8c153$3b40fbe0$0e09a8c0@dvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-ru-general by date

  From Date Subject
Next Message apm 2008-05-31 05:38:53 Не используется индекс в запросе.
Previous Message pronix pronix 2008-05-20 13:40:28 ограничение пользователя постгреса