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 19285433937.20020909003739@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  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Hello Bruce,

Monday, September 9, 2002, 12:22:26 AM, you wrote:

BM> Steve Howe wrote:
>> JC>      return OID if sum of all replacement INSERTs in the rule inserted
>> JC>        only one row, else zero
>> I don't agree with this one since it would lead us to a meaningless
>> information... what would be the number retrieved ? Not an OID, nor
>> nothing.

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.

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



pgsql-hackers by date:

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