Postgres Pro
Downloads
Home   >   mailing lists

How to get total number of rows when using LIMIT/OFFSET? - Mailing list pgsql-sql

From Dirk Lutzebaeck
Subject How to get total number of rows when using LIMIT/OFFSET?
Date
Msg-id 15660.10182.92232.720222@cayambe.core.aeccom.com
Whole thread Raw
Responses Re: How to get total number of rows when using LIMIT/OFFSET?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Petr Jezek
Date:
Subject: Re: Bad SUM result
Next
From: Achilleus Mantzios
Date:
Subject: Re: Error with DISTINCT and AS keywords