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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
