How many rows if limit wasn't present? - Mailing list pgsql-general

From Victor Spång Arthursson
Subject How many rows if limit wasn't present?
Date
Msg-id A77937EE-D66B-4D95-A7F7-54BC2F03D92F@tosti.dk
Whole thread Raw
Responses Re: How many rows if limit wasn't present?
List 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 by date:

Previous
From: Stephane Bortzmeyer
Date:
Subject: REFERENCES ignored when there is inheritance?
Next
From: "Devrim GUNDUZ"
Date:
Subject: Re: Postgres 8.0.3 Fedora RPMS ?