Re: BUG #9010: partition by overrides order by in window functions

markella.skempri wrote
> 1 2011-08-20 2011-08-21 1
> 1 2011-08-21 2011-08-27 6
> 1 2011-08-27 2011-08-28 1
> 1 2011-08-28 2011-08-29 1
> 1 2011-08-29 2011-08-30 1
>
> 1 2011-08-20 2011-08-21 1
> 1 2011-08-27 2011-08-28 1 7
> 1 2011-08-21 2011-08-27 6 1
> 1 2011-08-28 2011-08-29 1 1
> 1 2011-08-29 2011-08-30 1 2

Yes, partitioning occurs before ordering. The syntax itself suggests that.

Can you explain why you expect the 27-28 row to belong to the "first" group
and not the "third"?

If that is a typo then you are looking for contiguous blocks with the same
gap-size. Once you've identified those blocks you can then partition on
them and performing your row_number.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-9010-partition-by-overrides-order-by-in-window-functions-tp5789343p5789377.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.