How many rows if limit wasn't present?

[Victor Spång Arthursson <victor@xxxxxxxx>]

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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq