[gnue] r8755 - trunk/gnue-common/doc/technotes

[reinhard]

Author: reinhard
Date: 2006-10-11 10:30:52 -0500 (Wed, 11 Oct 2006)
New Revision: 8755

Modified:
   trunk/gnue-common/doc/technotes/00016.txt
Log:
Updated info about DB behaviour.


Modified: trunk/gnue-common/doc/technotes/00016.txt
===================================================================
--- trunk/gnue-common/doc/technotes/00016.txt   2006-10-11 14:33:05 UTC (rev 
8754)
+++ trunk/gnue-common/doc/technotes/00016.txt   2006-10-11 15:30:52 UTC (rev 
8755)
@@ -90,39 +90,96 @@
 F-Read : number of fractional digits for seconds on a 'read'
 F-Write: number of fractional digits for seconds on a 'write'
 
-psycopg:
---------
+psycopg < 1.1.19:
+-----------------
 
-Column      Datatype             F-Read    F-Write
+Column      Datatype             F-Read      F-Write
 ------------------------------------------------------------------------------
 date        mx.DateTime
-time        mx.DateTimeDelta     6-dig *1  No
-datetime    mx.DateTime          6-dig *1  No
+time        mx.DateTimeDelta     6-dig [1]   No
+datetime    mx.DateTime          6-dig [1]   No
 boolean     int
 string      str
 
-[*1]: Fractional part is parsed using sscanf () which means it will fail if the
-      decimal character (as defined by the locale) is different from '.'.
+[1]: Fractional part is parsed using sscanf() which means it will fail if the
+     decimal character (as defined by the locale) is different from '.'.
 
 
-pygresql:
----------
+psycopg 1.1.20
+--------------
 
+Column      Datatype             F-Read      F-Write
+------------------------------------------------------------------------------
+date        mx.DateTime
+time        mx.DateTimeDelta     6-dig       broken
+datetime    mx.DateTime          6-dig       broken
+boolean     int
+string      str
+
+
+psycopg 1.1.21
+--------------
+
+Column      Datatype             F-Read      F-Write
+------------------------------------------------------------------------------
+date        mx.DateTime
+time        mx.DateTimeDelta     6-dig       6-dig [1]
+datetime    mx.DateTime          6-dig       6-dig [1]
+boolean     int
+string      str
+
+[1]: broken for locales with a decimal characther other than '.' and for
+     seconds below 10.
+
+
+psycopg2
+--------
+
+Column      Datatype             F-Read      F-Write
+------------------------------------------------------------------------------
+date        datetime.date
+time        datetime.time        6-dig       6-dig
+datetime    datetime.datetime    6-dig       6-dig
+boolean     bool
+string      str
+
+
+pygresql 3.6.1:
+---------------
+
 Column      Datatype             F-Read    F-Write
 ------------------------------------------------------------------------------
 date        string                         
-time        string               No        2 digits [*2]
-datetime    string               No        2 digits [*1]
+time        string               No        2 digits [2]
+datetime    string               No        2 digits [1]
 boolean     bool
 string      str
 
-[*1] Make sure the decimal separator is set to "." (locale), otherwise writing
-     dates, times or datetimes fails with an exception
-[*2] Driver throws an exception if a time is given as built by pygresql.Time ()
-     (which creates an mx.DateTimeDelta). Instead use a pygresql.Timestamp ()
-     value (which is a mx.DateTime) !
+[1] Make sure the decimal separator is set to "." (locale), otherwise writing
+    dates, times or datetimes fails with an exception
+[2] Driver throws an exception if a time is given as built by pygresql.Time ()
+    (which creates an mx.DateTimeDelta). Instead use a pygresql.Timestamp ()
+    value (which is a mx.DateTime) !
 
 
+pygresql 3.8.1:
+---------------
+
+Column      Datatype             F-Read    F-Write
+------------------------------------------------------------------------------
+date        string                         
+time        string               6-dig     2 digits [2]
+datetime    string               6-dig     2 digits [1]
+boolean     bool
+string      str
+
+[1] Make sure the decimal separator is set to "." (locale), otherwise writing
+    dates, times or datetimes fails with an exception
+[2] Driver throws an exception if a time is given as built by pygresql.Time ()
+    (which creates an mx.DateTimeDelta). Instead use a pygresql.Timestamp ()
+    value (which is a mx.DateTime) !
+
+
 pypgsql:
 --------
 
@@ -131,12 +188,13 @@
 date        mx.DateTime                    
 time        mx.DateTimeDelta     2 digits  2 digits [*1]
 datetime    mx.DateTime          2 digits  2 digits [*1]
-boolean     pgBoolean
+boolean     PgBoolean
 string      str
 
 [*1] Make sure the decimal separator is set to "." (locale), otherwise writing
      dates, times or datetimes fails with an exception
 
+
 kinterbasdb:
 ------------