using named windows in with clauses
Is using named windows not allowed in with clauses? create table testa (a integer, b integer); works: with x as ( select sum(b) over (partition by b) from testa ) select * from x; fails with: ERROR: Window "w1" does not exist with x as ( select sum(b) over w1 from testa window w1 as (partition by b) ) select * from x
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.