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
-~----------~----~----~----~------~----~------~--~---

Reply via email to