Re: Proposal: Solving the "Return proper effected tuple count - Mailing list pgsql-hackers

From Steve Howe
Subject Re: Proposal: Solving the "Return proper effected tuple count
Date
Msg-id 7385990307.20020909004656@carcass.dhs.org
Whole thread Raw
In response to Re: Proposal: Solving the "Return proper effected tuple  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Proposal: Solving the "Return proper effected tuple count  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Hello Bruce,

Monday, September 9, 2002, 12:39:20 AM, you wrote:

>> BM> I don't understand this objection.
>> I misunderstood Joe's statement into thinking we wanted to sum the
>> OIDs for all INSERT commands applied :)
>> Please ignore this.
>> But now that I read it again, I would prefer having at least one OID
>> for the last inserted row. With this info, I would be able to refresh
>> my client dataset to reflect the new inserted rows.
>> 
>> I see returning 0 if multiple INSERT commands issued is as weird as
>> returning some OID if multiple INSERT commands issued. But the second
>> options is usable, while the first one is useless... So I would prefer
>> retrieving the last inserted OID.

BM> We would return 0 for oid and an insert count, just like INSERT INTO ...
BM> SELECT.  How is that weird?
It's not weird, or as weird as the other proposal which is retrieving
the last inserted OID number. If we can return some information for
the client, why not doing it ? :-)

------------- 
Best regards,Steve Howe                           mailto:howe@carcass.dhs.org



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Proposal: Solving the "Return proper effected tuple
Next
From: Bruce Momjian
Date:
Subject: Re: Proposal: Solving the "Return proper effected tuple count