| Lists: | pgsql-bugs |
|---|
| From: | "Jim Michaels" <jmichae3(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4985: LIMIT documentation is insufficient |
| Date: | 2009-08-13 23:32:38 |
| Message-ID: | 200908132332.n7DNWchb090189@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4985
Logged by: Jim Michaels
Email address: jmichae3(at)yahoo(dot)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."
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Cc: | "Jim Michaels" <jmichae3(at)yahoo(dot)com> |
| Subject: | Re: BUG #4985: LIMIT documentation is insufficient |
| Date: | 2009-08-14 05:42:44 |
| Message-ID: | 200908140842.46670.peter_e@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
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(at)yahoo(dot)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.