Andrew Dunstan wrote:
> >>> 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?
> >>>
> >> No, it's a known limitation.
> >>
Bruce Momjian wrote:
Heikki Linnakangas wrote:
dvs wrote:
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?
No, it's a known limitation
Heikki Linnakangas wrote:
> dvs wrote:
> > 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?
>
> No, it's a known limitation.
dvs wrote:
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?
No, it's a known limitation.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprise
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