Re: [sqlalchemy] EXTRACT() not working as expected in PostgreSQL with TIMESTAMP WITH TIMEZONE

2013-06-04 Thread Michael Bayer
On Jun 4, 2013, at 4:53 AM, Martijn van Oosterhout wrote: > I have just upgraded sqlalchemy and am running some tests on some old code > and getting some very strange results. > > I have a table with a column defined as TIMESTAMP WITH TIMEZONE: > > test_table = Table('test', metadata, > C

[sqlalchemy] EXTRACT() not working as expected in PostgreSQL with TIMESTAMP WITH TIMEZONE

2013-06-04 Thread Martijn van Oosterhout
I have just upgraded sqlalchemy and am running some tests on some old code and getting some very strange results. I have a table with a column defined as TIMESTAMP WITH TIMEZONE: test_table = Table('test', metadata, Column('id', Integer, primary_key=True), Column('data', UnicodeText, pr