Thread: BUG #4985: LIMIT documentation is insufficient
The following bug has been logged online: Bug reference: 4985 Logged by: Jim Michaels Email address: jmichae3@yahoo.com PostgreSQL version: 8.4.0 Operating system: XP Pro Sp3 Description: LIMIT documentation is insufficient Details: http://www.postgresql.org/docs/8.4/interactive/sql-select.html#SQL-LIMIT please add "OFFSET is zero-based. If you go past the boundaries, you will get no record."
On Friday 14 August 2009 02:32:38 Jim Michaels wrote: > The following bug has been logged online: > > Bug reference: 4985 > Logged by: Jim Michaels > Email address: jmichae3@yahoo.com > PostgreSQL version: 8.4.0 > Operating system: XP Pro Sp3 > Description: LIMIT documentation is insufficient > Details: > > http://www.postgresql.org/docs/8.4/interactive/sql-select.html#SQL-LIMIT > > please add "OFFSET is zero-based. If you go past the boundaries, you will > get no record." OFFSET is documented as the number of records to skip before starting to return rows. That would imply that OFFSET 0 skips no rows.