Nick Bower wrote: > > 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.
i think you want to look at extract(), which generates EXTRACT on the SQL side. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
