Re: Views and Limits

Alex  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