[GENERAL] Equivalent for mysql's FOUND_ROWS()

[Victor Spång Arthursson]

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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly