Re: BUG #4985: LIMIT documentation is insufficient

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: BUG #4985: LIMIT documentation is insufficient
Дата
Msg-id 200908140842.46670.peter_e@gmx.net
обсуждение исходный текст
Ответ на BUG #4985: LIMIT documentation is insufficient  ("Jim Michaels" <jmichae3@yahoo.com>)
Список 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@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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUG #4976: pgadmin - reconnect to drop database
Следующее
От: Dave Page
Дата:
Сообщение: Re: Malfunction in dropping database with pgAdmin