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()
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
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