Dne 9.3.2010 10:19, Martijn Tonies napsal(a):

> Hello Pepak,
>
> What's wrong with a normal VIEW and adding a WHERE
> clause when you do a SELECT?
>

Apart from the fact that it won't work, nothing :-)

Even that simple example of mine would be quite problematic with views;
essentially, you would have to rewrite all of the view's content into
your select - that SUM() would need to be outside the view. Of course,
that is feasible with that example, but just a little more complex
expression would quickly become infeasible.

Pepak