Subject says it all I guess:
What's the most efficient way of determining the number of rows that
_would_ be returned after/for a SELECT? Or is this impossible without...
actually... _doing_ a SELECT?
Basically this is for pagination purposes; given a SELECT statement, say,
'SELECT * from table LIMIT 10 OFFSET 10', I'd like to know how many total
rows would be returned if LIMIT and OFFSET weren't used in the statement.
Basically, same thing this guy was asking for a while ago:
Thanks for the assistance!
pgsql-novice by date
|Next:||From: Andrew Hammond||Date: 2006-07-29 00:16:14|
|Subject: Re: number of rows returned from SELECT|
|Previous:||From: James G Wilkinson||Date: 2006-07-28 22:36:05|
|Subject: Re: Time Zone Setting|