Re: Proposal: Solving the "Return proper effected tuple count

Joe Conway wrote:
> Sure, but that's why I am in favor of changing the tag. If you did:
>
> DELETE FROM fooview WHERE name LIKE 'Joe%';
>
> and got:
>
> MUTATED 507324 3
>
> it would mean that 3 tuples in total were affected by all of the
> substitute operations, only of of them being an INSERT, and the Oid of
> the lone INSERT was 507324. If instead I got:
>
> DELETE 0
>
> I'd be back to having no useful information. Did any rows in fooview
> match the criteria "LIKE 'Joe%'"? Did any data in my database get
> altered? Can't tell from this.

OK. Do any people have INSTEAD rules where there are not commands
matching the original query tag? Can anyone think of such a case being
created?

The only one I can think of is UPDATE implemented as separate INSERT and
DELETE commands.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073