Re: Interval and mx.TimeDelta
Federico Di Gregorio <fog-NGVKUo/i/[email protected]>
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Organization | initd.org |
| Message-ID | <[email protected]> |
Il giorno ven, 30/05/2008 alle 00.16 +0100, Eoghan Murray ha scritto: > Hi, > > I'm trying to use mx.TimeDelta with an postgres interval data type > (through SQLAlchemy) > My psycopg version is: > 2.0.6 (dec mx dt ext pq3) > > It all works fine until I get to dates greater than a day; > ProgrammingError: (ProgrammingError) invalid input syntax for type > interval: "1:00:00:00.00" > I assume this should be in the format: "24:00:00.00" > > Any advice? Yes, don't use mx. psycopg likes much better python built-in types. Anyway, that seems a bug in psycopg and I'll have a look at it. federico -- Federico Di Gregorio http://people.initd.org/fog Debian GNU/Linux Developer [email protected] INIT.D Developer fog-NGVKUo/i/[email protected] Se il sesso non ammacca è una patacca (!) -- Camilla Carotina _______________________________________________ Psycopg mailing list Psycopg-IAPFreCvJWPBWskQ1e/[email protected] http://lists.initd.org/mailman/listinfo/psycopg
signature.asc
(application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBIPz6KvcCgrgZGjesRAl9AAJ9fAjiCFl+rJwGpMGUgIEJe1ogDCQCgqUp3 PT0bGxutMSk0ISj/lvWxKwo= =3O0O -----END PGP SIGNATURE-----