On 3/7/21 11:24 AM, Pavel Stehule wrote: >> >> And so you are now mandating an ORDER BY on every query and in every >> aggregate and/or window function. Users will not like that at all. I >> certainly shan't. >> > > The mandatory ORDER BY clause should be necessary for operations when the > result depends on the order. You need an order for calculation of median. > And you don't need to know an order for average. More if the result is one > number and is not possible to do a visual check of correctness (like > median).
The syntax for median (percentile_cont(0.5)) already requires an order by clause. You are now requiring one on array_agg(). -- Vik Fearing
