select_win_sum_null.sql 222 B

12345678
  1. --!syntax_pg
  2. select x,y,sum(x) over w
  3. from (values (1,2),(null::int4,3),(2,4),(2,5)) as a(x,y)
  4. window w as ();
  5. select x,y,sum(x) over w
  6. from (values (1,2),(null::int4,3),(2,4),(2,5)) as a(x,y)
  7. window w as (order by y);