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> > ... > > <window specification details> ::= > [ <existing window name> ] > [ <window partition clause> ] > [ <window order clause> ] > [ <window frame clause> ] > > > <window partition clause> ::= > PARTITION BY <window partition column reference list> > ... > <window partition column reference> ::= > <column reference> [ <collate clause> ] > <window order clause> ::= > ORDER BY <sort specification list> > > etc. > > > On Apr 14, 10:14 pm, botz <[email protected]> wrote: >> 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 <[email protected]> wrote: >> >> >> >> >> >> >> >>> Here's a quick example: >> >>> the query form i'm aiming for is: >> >>> select x - lag(x) over ( order by x ) from a; >> >>> meta=MetaData() >>> a = Table('a', meta, Column('x',Integer)) >>> print select([ a.c.x , over( func.lag(a.c.x), order_by = >>> a.c.x ) ] ) # no problem >>> print select([ a.c.x - over( func.lag(a.c.x), order_by = >>> a.c.x ) ] ) # this one fails to compile >> >>> Here's the error: >> >>> print select([ a.c.x - over( func.lag(a.c.x), order_by = >>> a.c.x ) ] ) >>> File "/usr/local/lib/python2.7/site-packages/SQLAlchemy-0.7b4dev- >>> py2.7-linux-x86_64.egg/sqlalchemy/sql/expression.py", line 276, in >>> select >>> **kwargs) >>> File "/usr/local/lib/python2.7/site-packages/SQLAlchemy-0.7b4dev- >>> py2.7-linux-x86_64.egg/sqlalchemy/sql/expression.py", line 4317, in >>> __init__ >>> self._froms.update(_from_objects(*self._raw_columns)) >>> File "/usr/local/lib/python2.7/site-packages/SQLAlchemy-0.7b4dev- >>> py2.7-linux-x86_64.egg/sqlalchemy/sql/expression.py", line 1165, in >>> _from_objects >>> return itertools.chain(*[element._from_objects for element in >>> elements]) >>> File "/usr/local/lib/python2.7/site-packages/SQLAlchemy-0.7b4dev- >>> py2.7-linux-x86_64.egg/sqlalchemy/sql/expression.py", line 3265, in >>> _from_objects >>> return self.left._from_objects + self.right._from_objects >>> TypeError: can only concatenate list (not "itertools.chain") to list > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
