Views and Limits

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Views and Limits
Date: 2003-09-09 05:53:03
Message-ID: 3F5D6ABF.1090504@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-09-09 05:54:10 Re: Another pimple on the type system
Previous Message Tom Lane 2003-09-09 04:19:48 Re: ISO 8601 "Time Intervals" of the "format with time-unit deignators"