Re: BUG #8061: Not count limit offset - Mailing list pgsql-bugs

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