I can add a switch into sqlite.py to not produce a CAST clause based on the version of sqlite being used. does anyone know offhand how to get sqlite's version from the pysqlite API ?
On Jul 10, 2006, at 4:21 PM, Charles Duffy wrote: > Michael Bayer wrote: >> with regards to CAST, the CAST youre seeing is generated by the >> polymorphic_union function and was needed to support postgres' >> pickiness with regards to typing. if some versions of sqlite do not >> support CAST (which versions ? hopefully its at least a sqlite3...) >> then the visit_cast() function in the sqlite.py module should be >> overridden to produce just the straight column name. > > From the changelog, it looks like SQLite 3.2.3 is where CAST was > introduced. > > > > ---------------------------------------------------------------------- > --- > Using Tomcat but need to do more? Need to support web services, > security? > Get stuff done quickly with pre-integrated technology to make your > job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > http://sel.as-us.falkag.net/sel? > cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Sqlalchemy-users mailing list > Sqlalchemy-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users