MySQL apparently is unable to store infinity in float columns, so SA can't do it either. Google have me this: http://forums.mysql.com/read.php?39,220571,220573#msg-220573
On 9 Okt., 18:22, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I have a sqlalchemy table with a float column, and I would like to be > able to store +/- infinity. I am using numpy, and have access to > np.inf. However, if I try and store this value, I get > > OperationalError: (OperationalError) (1054, "Unknown column > 'Infinity' in 'field list'") > > Is there a way to store infinity using sqlalchemy with a mysql > backend? > > In [128]: sa.__version__ > Out[128]: '0.5.0beta4' > > [EMAIL PROTECTED]:~> mysql --version > mysql Ver 12.22 Distrib 4.0.24, for pc-solaris2.10 (i386) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---