[PyGreSQL] DATETIME fields and DateTime objects in pgdb

[Mario Frasca]

hallo you all,

I'm a developer and a user of pygresql (actually pgdb).  each time I
get a newer version of pgdb, I have to apply a small patch, as described
in http://ibo.sourceforge.net/IboPyInstallation.html.

I'm wondering if there are any thoughts to include something similar to
pgdb at any point in the future.

the problem:

pgdb returns DATETIME data as strings.  in the case switch for DATETIME
pgdb does not make any attempt to convert it from the representing
string into a DateTime object.  the result returned in fetch(one/all)
does not hold any information about the original type in the database
(indistinguishable from STRING).

conversely, a DateTime object cannot be put into a DATETIME field.

my patch relies on the ISO-somenumber format for date/time strings.
I understand that in general this can be a problem, so maybe an extra
function could be needed to inform the library about the correct format
to use with a specific database connection.  I did not code this since
I never encountered the problem.

thanks to everybody,
Mario Frasca.

-- 
Windows hasn't increased computer literacy. It's just lowered the standard.