Re: Fwd: DB2-style INS/UPD/DEL RETURNING

From: Lukas Smith <smith(at)pooteeweet(dot)org>
To: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Subject: Re: Fwd: DB2-style INS/UPD/DEL RETURNING
Date: 2006-03-13 16:33:22
Message-ID: 44159ED2.6030009@pooteeweet.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 should be really easy. It's easy to make
> generalized statements, so let's see an example to compare.

Ah, I was just not clear on what you were comparing this against. So
nevermind.

regards,
Lukas

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter 2006-03-13 16:43:24 Transaction eating up all RAM
Previous Message Jonah H. Harris 2006-03-13 16:30:45 Fwd: DB2-style INS/UPD/DEL RETURNING