Yeah SQL 2003 standard says no comma between window specification
details generally,
and postgresql, oracle at least aren't expecting it.
(ansi 2003 draft:)
7.11 window clause
...
window specification details ::=
[ existing window name ]
[ window partition clause ]
[ window order clause ]
[
yeah got your ticket someone will get to it today hopefully, thanks !
On Apr 15, 2011, at 9:47 AM, botz wrote:
Yeah SQL 2003 standard says no comma between window specification
details generally,
and postgresql, oracle at least aren't expecting it.
(ansi 2003 draft:)
7.11 window clause
Great, thanks for the quick fix.
Found another minor bug with the window functions,
syntax should be
( partition by x order by y)
not
( partition by x, order by y)
... at least for postgresql.
On Apr 14, 8:51 pm, botz randa...@gmail.com wrote:
Here's a quick example:
the query form i'm