Re: [HACKERS] Fwd: DB2-style INS/UPD/DEL RETURNING

2006-03-13 Thread Lukas Smith
Jonah H. Harris wrote: In the end, how is this more efficient or easy than: INSERT INTO test_tbl VALUES (nextval('test_id_seq'), 'John Doe') RETURNING test_id; OR SELECT test_id FROM NEW TABLE INSERT INTO test_tbl VALUES (nextval('test_id_seq'), 'John Doe'); Based on your statement, this s

[HACKERS] Fwd: DB2-style INS/UPD/DEL RETURNING

2006-03-13 Thread Jonah H. Harris
On 3/13/06, Lukas Smith <[EMAIL PROTECTED]> wrote: I guess you could get the same effect from a transaction. If there ismuch network overhead you could also write a stored procedure. This isobviously "more direct". Due to caching I am not sure how much performance improvement there is in doing