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
Robert ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Sqlalchemy-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
