2011/10/15 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> I can't recall whether there was some good reason for underspecifying
> these test queries. It looks like all the problematic ones were added in
> commit ec4be2ee6827b6bd85e0813c7a8993cfbb0e6fa7 "Extend the set of frame
> options supported for window functions", which means it was either me or
> Hitoshi-san who wrote them that way, but memory is not serving this
> afternoon.
>
I don't remember if I wrote that part or not, but I like to add
explicit ORDER BY to the test cases. It doesn't appear that some
reason stopped us to specify it. So +1 for adding the clauses.
Regards,
--
Hitoshi Harada