Hi - I have a pg table with a timestamp column, and have mapped this to dateTime.
I've read and re-read the sqlalchemy docs, and func source, but it's not clear to me how I adapt an existing query (constructed by session.query(...).filter(...)) to do these simple aggregates; 1) Return list of district years (possibly with number of rows in each if possible) 2) For year X, return distinct list of days that there are rows for. All this seems to hinge on having access to a sql function that operators on the timestamp server-side. Thanks, Nick --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---