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

Поиск
Список
Период
Сортировка
От Ken Tanzer
Тема [GENERAL] Ordering of window functions with no order specified?
Дата
Msg-id CAD3a31WwGBCoPK+KtLBzLdq8o_bJd6n9mha1hgLuGi4jKZBo6w@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Ordering of window functions with no order specified?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: [GENERAL] Ordering of window functions with no order specified?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Hi.  If you use a window function and don't specify an order, will the rows be processed in the same order as the query results?

In this particular case, I'm wondering about row_number(), and whether I explicitly need to repeat the ordering that's already specified in the query?

SELECT a,b,c,row_number()
OVER (PARTITION BY a) -- Do I need an ORDER BY c,b here?
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?)

Thanks!

Ken



--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

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

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