Better documentation for row_number() combined with set returningfunctions

Поиск
Список
Период
Сортировка
От Erik Tews
Тема Better documentation for row_number() combined with set returningfunctions
Дата
Msg-id e5116f96a53b73c1f3dff05d35218d146e622262.camel@datenzone.de
обсуждение исходный текст
Ответы Re: Better documentation for row_number() combined with setreturning functions  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
Hi

The current documentation of Postgresql sounds like row_number() over
() can be used to number the rows returned by postgres. However, that
doesn't work when the query also uses set returning functions such as
json_array_elements. In this case, row_number() will be the same for
every element of the set.

I suggest to add a paragraph to the description of row_number() that
states that this is the behaviour and maybe also reference the "with
ordinality" feature that can be used instead.

Erik

Вложения

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

Предыдущее
От: David Glasser
Дата:
Сообщение: Re: No docs for interaction of ON DELETE/UPDATE and permissions
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: No docs for interaction of ON DELETE/UPDATE and permissions