win_expr_bounds.sql 258 B

12345678910111213
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. use plato;
  4. declare $begin as Int32;
  5. select
  6. key, subkey,
  7. COUNT(*) over w as cnt
  8. from Input4
  9. window
  10. w as (order by key, subkey rows between $begin preceding and 1 + 1 following)
  11. order by key, subkey;