Em Sex, 2013-04-12 às 14:57 +0000, claudio...@hotmail.com escreveu: > The following bug has been logged on the website: > > Bug reference: 8061 > Logged by: Claudio Oliveira > Email address: claudio...@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]: "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: gue...@guedesoft.net - skype: guediz http://guedesoft.net - http://www.postgresql.org.br http://www.rnp.br/keyserver/pks/lookup?search=0x8F3E3C06D428D10A
signature.asc
Description: This is a digitally signed message part