With mysql it's possible to add a parameter "SQL_CALC_FOUND_ROWS" to
the selectstatement and then after having made a query to the database
with a limit clause you can fire off a second query, "SELECT
found_rows() as numberofrows" to get the number of rows the query would
have returned without the LIMIT-clause…
I wonder, is there any way, exept splitting the query up and make
different calls to the database, to accomplish the same with postgresQL
as with mysql?
Sincerely
Victor