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
-~----------~----~----~----~------~----~------~--~---

Reply via email to