Alex <alex(at)meerkatsoft(dot)com> writes:
> Is there a way to get change that i.e. that the VIEW places a limit on
> the final result?
How would that possibly make any sense? A view is supposed to be a
self-contained, logically consistent object ... not something that
exerts magical action-at-a-distance powers upon queries that reference
it. As an example, would you still expect this restriction to work when
the view was used in a join, SELECT DISTINCT, or aggregate query? If
so, just what is getting limited?
regards, tom lane