Re: [GENERAL] Ordering of window functions with no order specified?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Ordering of window functions with no order specified?
Дата
Msg-id CAKFQuwYGnfYUqkMG5=g46YeKTk3Lhpos=Ro545OrhoHA1W572w@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Ordering of window functions with no order specified?  (Ken Tanzer <ken.tanzer@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Wednesday, June 14, 2017, Ken Tanzer <ken.tanzer@gmail.com> wrote:
SELECT a,b,c,row_number()
OVER (PARTITION BY a) -- Do I need an ORDER BY c,b here?

Yes.
 
FROM foo
ORDER  BY c,b 
Also, I'm interested in both what if any behavior is guaranteed, and what gets done in practice.  (i.e., a SELECT with no order doesn't have guarantees, but in practice seems to return the results in the order they were added to the table.  Is it something similar here?)

Row numbers would be assigned in the order they are sent up by the "from foo" clause.

In practice what gets done depends on the execution plan that is chosen and nothing is guaranteed unless you specify it in the query so that the execution plan can enforce it.

David J.

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

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: [GENERAL] Ordering of window functions with no order specified?
Следующее
От: Rory Campbell-Lange
Дата:
Сообщение: Re: [GENERAL] Repmgr + pgbouncer - Notification of master promotionto application level ...