Equivalent for mysql's FOUND_ROWS()

Victor Sp�ng Arthursson wrote:

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?

Don't use LIMIT.

Open a cursor for the select, fetch the number of rows you want, if the
FETCH returned that many, do a "MOVE FORWARD ALL IN <cursorname>". The
number of rows skipped by the MOVE will be PQcmdTuples(result), so the
rows you got from FETCH plus that number is the information you're
looking for.

Jan

Sincerely

Victor

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #