Re: [GENERAL] Nested window functions not permitted

On Sun, 2015-11-08 at 17:50 -0500, Tom Lane wrote: > Oliver Elphick writes: > > I tried to do this: > > SELECT p.company, p.start, p.yearend, p.idnum, > >s.pdno, s.pdend, > >CASE WHEN nth_value(s.pdend,(row_number() OVER w)::INTEGER -1) > > OVER w IS NULL > >

Re: [GENERAL] Nested window functions not permitted

Oliver Elphick writes: > I tried to do this: > SELECT p.company, p.start, p.yearend, p.idnum, >s.pdno, s.pdend, >CASE WHEN nth_value(s.pdend,(row_number() OVER w)::INTEGER -1) > OVER w IS NULL > THEN p.start > ELSE nth_value(s.pdend,(row

[GENERAL] Nested window functions not permitted

I tried to do this: SELECT p.company, p.start, p.yearend, p.idnum, s.pdno, s.pdend, CASE WHEN nth_value(s.pdend,(row_number() OVER w)::INTEGER -1) OVER w IS NULL THEN p.start ELSE nth_value(s.pdend,(row_number() OVER w)::INTEGER -1) + '1