>>> from pysqlite2 import dbapi2
>>> dbapi2.sqlite_version
'3.3.4'

On 7/10/06, Michael Bayer < [EMAIL PROTECTED]> wrote:
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



--
Jonathan Ellis
http://spyced.blogspot.com
-------------------------------------------------------------------------
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

Reply via email to