Views and Limits - Mailing list pgsql-general

From Alex
Subject Views and Limits
Date
Msg-id 3F5D6ABF.1090504@meerkatsoft.com
Whole thread Raw
Responses Re: Views and Limits
List pgsql-general
Hi,

I am using a view that has also a LIMII 1000 in it. As it seems when I
run a query with a WHERE then the WHERE is only applied to the subset of
1000 records. So although the query my produce 3000 records, I may get
only a few hundred back.

Is there a way to get change that i.e. that the VIEW places a limit on
the final result?

Thanks
Alex



pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Another pimple on the type system
Next
From: Tom Lane
Date:
Subject: Re: Another pimple on the type system