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
