BUG #4985: LIMIT documentation is insufficient

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.