pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to get total number of rows when using LIMIT/OFFSET?
2+ messages / 2 participants
[nested] [flat]
* How to get total number of rows when using LIMIT/OFFSET?
@ 2002-07-10 12:25 Dirk Lutzebaeck <lutzeb@aeccom.com>
2002-07-11 01:50 ` Re: How to get total number of rows when using LIMIT/OFFSET? Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Dirk Lutzebaeck @ 2002-07-10 12:25 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to get total number of rows when using LIMIT/OFFSET?
2002-07-10 12:25 How to get total number of rows when using LIMIT/OFFSET? Dirk Lutzebaeck <lutzeb@aeccom.com>
@ 2002-07-11 01:50 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2002-07-11 01:50 UTC (permalink / raw)
To: Dirk Lutzebaeck <lutzeb@aeccom.com>; +Cc: pgsql-sql
Dirk Lutzebaeck wrote:
>
> 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.
No way to do that. Perhaps a CURSOR and look at the total count. Not
sure if that works but I think it should.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-07-11 01:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-10 12:25 How to get total number of rows when using LIMIT/OFFSET? Dirk Lutzebaeck <lutzeb@aeccom.com>
2002-07-11 01:50 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox