A query that doesn't rely on broken GROUP BY might look like
select([forum_topics, select([func.max(forum_posts.c.created)], forum_posts.c.topic_id==forum_topics.c.id, scalar=True).label('last_post')], order_by=[desc('last_post')]) On 12/28/06, Mart <[EMAIL PROTECTED]> wrote:
Thanks, it worked! On Dec 28, 6:47 pm, "Michael Bayer" <[EMAIL PROTECTED]> wrote: > actually the GROUP BY wont go through as a keyword argument to > query.select() at the moment, so youd have to use the full select > statement. but also, i dont see why youd want that GROUP BY in the > query, you dont have any aggregate functions in your column list and > also GROUP BY requires all non-aggregates to be part of the group (at > least in postgres). In MySQL and SQLite the GROUP BY removes the duplicate entries. (For every post in the topic there is a row of that topic in the result.)
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---