I am trying to retrieve unique users from a table using this: results = sa_session.query(TempScore).group_by(TempScore.user_name)
This unfortunately causes the error below: "There was a problem: (ProgrammingError) column "temp_scores.id" must appear in the GROUP BY clause or be used in an aggregate function" Could someone tell me what the SA 0.4 syntax would be for this query? I am using Postgresql Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---