Re: [HACKERS] WIP patch for basic window frame support

2009-01-04 Thread Tom Lane
"Hitoshi Harada" writes: > 2008/12/31 Tom Lane : >> RANGE UNBOUNDED PRECEDING -- same as AND CURRENT ROW >> ROWS UNBOUNDED PRECEDING-- same as AND CURRENT ROW > Is this true? 7.11 syntax rule 9 says so. AFAICS general rule 5b doesn't discuss the case where isn't present, and does

Re: [HACKERS] WIP patch for basic window frame support

2009-01-04 Thread Hitoshi Harada
2009/1/5 Tom Lane : > "Hitoshi Harada" writes: >> 2008/12/31 Tom Lane : >>> RANGE UNBOUNDED PRECEDING -- same as AND CURRENT ROW >>> ROWS UNBOUNDED PRECEDING-- same as AND CURRENT ROW > >> Is this true? > > 7.11 syntax rule 9 says so. AFAICS general rule 5b doesn't discuss the > cas

Re: [HACKERS] WIP patch for basic window frame support

2009-01-04 Thread Hitoshi Harada
2008/12/31 Tom Lane : > No docs or regression tests yet, but it seems to work ... please check > against Oracle and DB2 behavior. Supported cases are > >RANGE UNBOUNDED PRECEDING -- same as AND CURRENT ROW >ROWS UNBOUNDED PRECEDING-- same as AND CURRENT ROW Is this t