Re: [sqlalchemy] array_agg() in ORM entities (0.5.8)?

2010-04-02 Thread David Gardner
I was able to come up with a work-around, since this is part of a report, I was able to format the dates as strings the way I was planning to do in python anyways: qry=session.query(Task, func.cat(func.to_char(TaskHistory.updated,'MM/DD/YY HH:MI am'))) This works well for my needs (cat()

[sqlalchemy] array_agg() in ORM entities (0.5.8)?

2010-04-01 Thread David Gardner
I was trying to use the Postrges array_agg() aggregate function against a column on a related table. In this case I wanted a list of timestamps from a related table, but I get an error that the list type is unhashable. The SQL that SA generates is as expected, and if I replace func.array_agg

Re: [sqlalchemy] array_agg() in ORM entities (0.5.8)?

2010-04-01 Thread Michael Bayer
On Apr 1, 2010, at 7:45 PM, David Gardner wrote: I was trying to use the Postrges array_agg() aggregate function against a column on a related table. In this case I wanted a list of timestamps from a related table, but I get an error that the list type is unhashable. The SQL that SA