Steve Howe writes:
> Here are the proposals for solutioning the "Return proper effected
> tuple count from complex commands [return]" issue as seen on TODO.
>
> Any comments ?... This is obviously open to voting and discussion.
We don't have a whole lot of freedom in this; this area is covered by the
SQL standard. The major premise in the standard's point of view is that
views are supposed to be transparent. That is, if
SELECT * FROM my_view WHERE condition;
return N rows, then a subsequently executed
UPDATE my_view SET ... WHERE condition;
returns an update count of N, no matter what happens behind the scenes. I
don't think this matches Tom Lane's view exactly, but it's a lot closer
than your proposal.
--
Peter Eisentraut peter_e@gmx.net