postgres timestamp broken in 0.6

[Former user]

Hey, I tried migrating my sa app to 0.6 but I use the sa.func.TIMESTAMP call. Apparently this is broken in 0.6. It adds parens around the date ie:

select timestamp('04/05/10');

instead of

select timestamp '04/05/10';

Note this is on Postgres 8.4.

Cheers

[Mike Bayer]

I'm not familiar with this behavior in any version of SQLAlchemy, and there's no special meaning to "func.TIMESTAMP" I can find going back to 0.3 (only CURRENT_TIMESTAMP and similar). Can you please specify version and attach a test script. You can use the compiler extension for now.

[Mike Bayer]

also note that the "TIMESTAMP 'xyz'" syntax is not generally needed as you just bind a datetime() to the statement, and the DBAPI handles the type conversion.

no test case or further info here so please reopen if further info is available.