BUG #8061: Not count limit offset

Em Sex, 2013-04-12 às 14:57 +0000, claudiomsi@hotmail.com escreveu:

The following bug has been logged on the website:

Bug reference: 8061
Logged by: Claudio Oliveira
Email address: claudiomsi@hotmail.com
PostgreSQL version: 9.2.4
Operating system: WIN 8
Description:

select count(*) from teste; --- 5000
select count(*) from teste limit 1000 offset 0; --- 5000
select count(*) from teste limit 1000 offset 1; --- not returning

From documentation [1]http://www.postgresql.org/docs/current/static/queries-limit.html:

"OFFSET says to skip that many rows before beginning to return rows.
OFFSET 0 is the same as omitting the OFFSET clause, and LIMIT NULL is
the same as omitting the LIMIT clause. If both OFFSET and LIMIT appear,
then OFFSET rows are skipped before starting to count the LIMIT rows
that are returned."

Notice that a "select count(*) from ... " will return _one_ line.

[1]: http://www.postgresql.org/docs/current/static/queries-limit.html

--
Dickson S. Guedes
mail/xmpp: guedes@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br
http://www.rnp.br/keyserver/pks/lookup?search=0x8F3E3C06D428D10A

claudiomsi@hotmail.com writes:

select count(*) from teste; --- 5000
select count(*) from teste limit 1000 offset 0; --- 5000
select count(*) from teste limit 1000 offset 1; --- not returning

Of course. I think perhaps what you are looking for is

select count(*) from (select 1 from teste limit ...) ss;

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs