Equivalent for mysql's FOUND_ROWS()

From: Victor Spång Arthursson <scooterbabe(at)home(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Equivalent for mysql's FOUND_ROWS()
Date: 2004-05-11 08:51:34
Message-ID: 67FF445C-A328-11D8-99EA-00039344A3C4@home.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

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?




Browse pgsql-general by date

  From Date Subject
Next Message Rory Campbell-Lange 2004-05-11 09:13:29 Postgres demo app [was: Re: nested elseif woes]
Previous Message Victor Spång Arthursson 2004-05-11 08:46:59 ORDER BY 'DK', 'DE', DESC?