Re: [sqlite] Float, numeric and query (Continued)

Igor Tandetnik <[EMAIL PROTECTED]> writes: > > Dom Dom <[EMAIL PROTECTED]> wrote: > > Igor Tandetnik <[EMAIL PROTECTED]> writes: > > > >> Would it be possible to get SQLAlchemy to cast to REAL, FLOAT or > >> DOUBLE rather than NUMERIC? > > Hi Igor, Thanks for answering. Seems SQLAlchemy had a

Re: [sqlite] Float, numeric and query (Continued)

Dom Dom <[EMAIL PROTECTED]> wrote: > Igor Tandetnik <[EMAIL PROTECTED]> writes: > >> Would it be possible to get SQLAlchemy to cast to REAL, FLOAT or >> DOUBLE rather than NUMERIC? > > Hello Igor, > Thanks for answering. > >> Casting to NUMERIC leaves integers as integers; >> basically, it's a no-o

[sqlite] Float, numeric and query (Continued)

Igor Tandetnik <[EMAIL PROTECTED]> writes: > Would it be possible to get SQLAlchemy to cast to REAL, FLOAT or DOUBLE > rather than NUMERIC? Hello Igor, Thanks for answering. >Casting to NUMERIC leaves integers as integers; > basically, it's a no-op in your query. Are you sure ? When I do in my

Re: [sqlite] Float, numeric and query

"Dom Dom" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >> The query, translated into sql by SQLAlchemy, is (it returns tuple >> objects): SELECT mytable.id AS mytable_id, mytable."colA" AS >> "mytable_colA", mytable."colB" AS "mytable_colB", mytable."colC" AS >> "mytable_colC", CAST(

[sqlite] Float, numeric and query

Hi, I am using SQLAlchemy which is an very nice ORM under python: http://www.sqlalchemy.org/ I am only an amateur. I attach a file, which will be helpful for people willing to help me. I am trying to make a query with a simple table containing integers and floats. The purpose of the query is to d