my understanding is that mx is no longer supported with psycopg2. You
might want to ask on their list; SA just passes through objects for
PG's date/time types.
On May 29, 2008, at 2:27 PM, Eoghan Murray wrote:
>
> Hi,
>
> I'm trying to use mx.TimeDelta instead of datetime.timedelta on an
> Interval column (with Postgres).
> It seems to work fine until I get to intervals > a day, at which point
> it fails with:
>
> ProgrammingError: (ProgrammingError) invalid input syntax for type
> interval: "1:00:00:00.00"
> 'INSERT INTO mytable (id, mytime) VALUES (%(id)s, %
> (mytime)s)' {'mytime': <mx.DateTime.DateTimeDelta object for
> '1:00:00:00.00' at 9a5bdb8>, 'id': 105461L}
>
> Any idea where I could hook in to give the desired "24:00:00.00"?
>
> Thanks!
>
> Eoghan
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
