Re: Equivalent for mysql's FOUND_ROWS()

[Jan Wieck <JanWieck(at)Yahoo(dot)com>]

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(at)postgresql(dot)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(at)Yahoo(dot)com #