From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: window function and order by |
Date: | 2013-12-21 00:08:53 |
Message-ID: | 25569.1387584533@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
=?ISO-8859-1?Q?Torsten_F=F6rtsch?= <torsten(dot)foertsch(at)gmx(dot)net> writes:
> select id, buy_price, sum(buy_price) over (order by id) sum
> from fmb
> where 202300<=id and id<=202400
> order by id;
> Do I need the ORDER BY clause at the end? Or does the ORDER BY in the
> window function already define the order of the result set?
According to the standard, you'd need the ORDER BY to guarantee any
particular ordering of the output. However, our implementation will
deliver the rows in the window function's order as long as there's
only one window function order (otherwise you get a more-or-less-
random one of them...). It won't cost anything to have the ORDER BY
though, so I'd recommend keeping it.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-12-21 00:12:47 | Re: Seems like bug in 9.1.3, need to confirm. |
Previous Message | AI Rumman | 2013-12-20 23:19:52 | Seems like bug in 9.1.3, need to confirm. |