Re: [HACKERS] cannot use result of (insert..returning)

2008-06-12 Thread Bruce Momjian
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. > >>

Re: [HACKERS] cannot use result of (insert..returning)

2008-06-11 Thread Andrew Dunstan
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

Re: [HACKERS] cannot use result of (insert..returning)

2008-06-11 Thread Bruce Momjian
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.

Re: [HACKERS] cannot use result of (insert..returning)

2008-06-04 Thread Heikki Linnakangas
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

[HACKERS] cannot use result of (insert..returning)

2008-06-03 Thread dvs
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