News for hackers. Stuff that matters.

dwanvik

Re:Advanced SQL window function quiz on Monday February 12, 2018 @09:07AM (#16358600)
Last time I checked, PG didn't support RANGE <value> PRECEDING, only RANGE UNBOUNDED PRECEDING. The new MySQL 8.0windowing functions do, though.
Re:Advanced SQL window function quiz on Monday February 12, 2018 @09:03AM (#16358574)
Check out the new MySQL 8.0 release candidate. Is has windowing functions now.

https://dev.mysql.com/doc/refman/8.0/en/window-functions.htm...