Hello,
If I do:
UPDATE table SET column = 'value' where column = 'othervalue';
in psql, I get something like
UPDATE 14.
But if 'table' is in fact a view, and I do the update via the rule:
CREATE RULE somerule AS ON UPDATE TO table DO INSTEAD select
somefunction(...);
I get 14 tuples back with the result of each somefuntion().
Defining somefunction() to return void doesn't help, I get 14 tuples
with null.
Is there a workaround for this behaviour? Shouldn't it be transparant
for a client whether an UPDATE is on a table or on a view ?
Cheers,
Han Holl