I posted it on the psycopg list at http://lists.initd.org/pipermail/psycopg/2008-April/006026.html, but it mangled my link to this discussion (by eating a space after the URL and appending the first word of the next sentence)
On Fri, Apr 18, 2008 at 9:34 PM, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > On Apr 18, 2008, at 10:20 PM, Matthew Dennis wrote: > > > I get a similar result if I use psycopg2 directly: > > > > #!/usr/bin/python > > > > import psycopg2 > > from datetime import datetime > > > > conn = psycopg2.connect('''dbname=testdb user=postgres > > host=localhost''') > > cur = conn.cursor() > > > > cur.execute("drop table if exists t0") > > cur.execute("create table t0(c0 timestamp(0) with time zone)") > > cur.execute("insert into t0 values(current_timestamp)") > > cur.execute("select c0 from t0 where c0 < %(bindArg)s - interval '1 > > hour'", {'bindArg':datetime.utcnow()}) > > > great. lets let them know on the psycopg2 list. > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---