How many rows if limit wasn't present?

From: Victor Spång Arthursson <victor(at)tosti(dot)dk>
To: pgsql-general(at)postgresql(dot)org
Subject: How many rows if limit wasn't present?
Date: 2005-05-13 10:29:10
Message-ID: A77937EE-D66B-4D95-A7F7-54BC2F03D92F@tosti.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2005-05-13 10:37:51 Re: Postgres 8.0.3 Fedora RPMS ?
Previous Message Stephane Bortzmeyer 2005-05-13 09:57:08 REFERENCES ignored when there is inheritance?