You can, but you have to use subqueries. Whatever that answer is you linked to doesn't work, at least not when I tested it.
I discuss the syntax problems at some length in the mail thread linked from that commitfest entry. IGNORE NULLs isn't the worst case; that patch also attempted to do "nth_value(...) from last" which as far as I can tell needs no less than 4 lookahead tokens
-
-
Do we have to do both in the same patch or can we split out IGNORE NULLS and already have that? FROM LAST would be nice but surely we can just sort the other direction for now.
-
No, we don't have to do both.
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
But being standards-compliant is both better ideologically and more elegant in practice.