claudio...@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