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: jmich...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
