Hi Oliver,
After studying the standard more, it seems I was totally wrong.
In summary, current code is correct. Sorry for noise.
>From the standard explaining lead():
> B) If OFFSET = 0 (zero), then the value of is the
> value of VE1 evaluated for the current row.
(here VE1 referes to the first
Hi Oliver,
I have just pushed a change to WinGetFuncArgInPartition() in
nodeWindowAgg.c to fix Coverity issues. So please update your git
respository.
> The result looks wrong. So I've just tried removing the "&& relpos != 0"
> and I get:
>
> SELECT x, y, lead(x, 0) IGNORE NULLS OVER w FROM g
>
