Views and Limits

Поиск
Список
Период
Сортировка
От Alex
Тема Views and Limits
Дата
Msg-id 3F5D6ABF.1090504@meerkatsoft.com
обсуждение исходный текст
Ответы Re: Views and Limits  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Another pimple on the type system
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Another pimple on the type system