Re: Parameters don't work in FETCH NEXT clause?

Поиск
Список
Период
Сортировка
От Shay Rojansky
Тема Re: Parameters don't work in FETCH NEXT clause?
Дата
Msg-id CADT4RqD=GaWMqbYbos_BWyrzapY5OvN=X05nASdoa2hWGkzGxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parameters don't work in FETCH NEXT clause?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
​Would something like this be valid?

OFFSET { start_literal | ( start_expression ) } { ROW | ROWS }
FETCH { FIRST | NEXT} [ count_literal | ( count_expression ) ] { ROW | ROWS } ONLY

Leaving the mandatory parentheses detail to the description, while adequate, seems insufficient - especially when a normal LIMIT expression is not so restricted.

​And don't you think the section header would be more accurately named:

Limit, Offset & Fetch Clauses

​The nuance regarding "different standard syntax" is unknown to the reader who first looks at the syntax and sees three different lines, one for each clause, and then scrolls down looking at headers until they find the section for the clause they are interested in.  That FETCH is an alias for LIMIT ​is not something that I immediately understood - though to be honest I don't think I comprehended the presence of FETCH on a SELECT query at all and thought it only pertained to cursors....


All these suggestions would definitely have saved me (and therefore this list!) some time.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: seg fault in contrib/bloom
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Reviewing freeze map code