Re: [Sqlalchemy-users] sqlalchemy creates Syntax Error with select GROUP BY and ORDER BY

[Andreas Kostyrka]

Am Sonntag, den 22.01.2006, 23:10 +1100 schrieb Robert Leftwich:
> Andreas Kostyrka wrote:
> > Hi!
> 
> Hello.
> 
> > 
> > What am I doing wrong?
> 
> Nothing.
> 
> > 
> > select([media.c.status, func.count(media.c.id)],
> > group_by=[media.c.status], order_by=[media.c.status],
> > *args).execute().fetchall():
> > 
> > provokes this error:
> > 
> > psycopg.ProgrammingError: ERROR:  syntax error at or near "GROUP" at
> > character 72
> > 
> > SELECT media.status, count(media.id)
> > FROM media ORDER BY media.status GROUP BY media.status
> > 
> 
> I've just checked in a change that reverses the ORDER_BY and GROUP BY output, 
> with tests to match. Let me know how it goes

Well, it works now :)

thx,

Andreas

> 
> Robert

signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil