On 2009-11-12, A. Kretschmer andreas.kretsch...@schollglas.com wrote:
Hi,
just to be sure, it is still (8.4) not possible to use RETURNING within an
other INSERT?
not in pure SQL, but it should be possible in PLPGSQL etc.
--
Sent via pgsql-general mailing list
Andreas Kretschmer akretsch...@spamfence.net wrote:
A. Kretschmer andreas.kretsch...@schollglas.com wrote:
Hi,
just to be sure, it is still (8.4) not possible to use RETURNING within an
other INSERT?
Thx for all replies. It is not a really problem, i will write a
benchmark to
Hi,
just to be sure, it is still (8.4) not possible to use RETURNING within an
other INSERT?
To show what i mean:
test=*# insert into foo2 (id1, id2) (insert into foo(n) values
('a'),('b'),('c') returning currval('some_sequence'), id);
ERROR: syntax error at or near insert
LINE 1: insert into
On Thu, Nov 12, 2009 at 1:41 PM, A. Kretschmer
andreas.kretsch...@schollglas.com wrote:
Hi,
just to be sure, it is still (8.4) not possible to use RETURNING within an
other INSERT?
it is being discussed for 8.5, but as far as features go - stable versions
don't change (at least change is
2009/11/12 A. Kretschmer andreas.kretsch...@schollglas.com:
Hi,
just to be sure, it is still (8.4) not possible to use RETURNING within an
other INSERT?
To show what i mean:
test=*# insert into foo2 (id1, id2) (insert into foo(n) values
('a'),('b'),('c') returning
On 12/11/2009 9:41 PM, A. Kretschmer wrote:
Hi,
just to be sure, it is still (8.4) not possible to use RETURNING within an
other INSERT?
Not directly, now. However, if I recall correctly in 8.4 you *CAN* use a
... RETURNING statement within an SQL function, and use the results of
that in
A. Kretschmer andreas.kretsch...@schollglas.com wrote:
Hi,
just to be sure, it is still (8.4) not possible to use RETURNING within an
other INSERT?
Thx for all replies. It is not a really problem, i will write a
benchmark to compare the new writeable CTE (in 8.5 alpha) with the old
style