Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> Possibly significant in this context is that there is a proof-of-concept
> patch in development for another part of T612, namely inverse
> distribution functions (e.g. percentile_disc and percentile_cont) which
> should be available by the next CF, and which will require a similar
> decision with respect to the keyword WITHIN (to support doing:
> select percentile_cont(0.5) within group (order by x) from ...;
> which returns the median value of x).
Agreed, separating out the function-call-with-trailing-declaration
syntaxes so they aren't considered in FROM and index_elem seems like
the best compromise.
If we do that for window function OVER clauses as well, can we make
OVER less reserved?
regards, tom lane