How many rows if limit wasn't present?

Поиск
Список
Период
Сортировка
От Victor Spång Arthursson
Тема How many rows if limit wasn't present?
Дата
Msg-id A77937EE-D66B-4D95-A7F7-54BC2F03D92F@tosti.dk
обсуждение исходный текст
Ответы Re: How many rows if limit wasn't present?  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Ciao!

Is it possible to get the number of rows that would have been
returned if the LIMIT-clause weren't  present in some way after the
query was run?

Reason for asking is that I have a really big chunk of SQL, which
takes time to execute, and whoose result is paginated using a LIMIT-
clause, and to get the actual result (before pagination) I have to
run the query one more time… Big slow down…

Thanks in advance,

Victor Spång Arthursson

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephane Bortzmeyer
Дата:
Сообщение: REFERENCES ignored when there is inheritance?
Следующее
От: "Devrim GUNDUZ"
Дата:
Сообщение: Re: Postgres 8.0.3 Fedora RPMS ?