How to get total number of rows when using LIMIT/OFFSET?

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to get total number of rows when using LIMIT/OFFSET?
Date: 2002-07-10 12:25:42
Message-ID: 15660.10182.92232.720222@cayambe.core.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello,

when using LIMIT/OFFSET is it possible to get also the total number of rows
besides the actual number of rows of the select? It should be there
because the whole list is ordered anyhow. I'm using 7.2.1.

Thanks for help,

Dirk

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2002-07-10 12:25:56 Re: Error with DISTINCT and AS keywords
Previous Message Andreas Schlegel 2002-07-10 11:57:52 Error with DISTINCT and AS keywords