Hi,
The following code returns a list of tuples to python from the db,
corresponding to the values of the 'snpval_id' column in the table 'cell'.
I was wondering if there was an easy way to have it return a list of
values (in this case, integers) instead.
*********************************************************************************
db =
create_engine("postgres://btsnp:pqxxro...@localhost:5432/btsnp_full_genome")
conn = db.connect()
result = conn.execute("select snpval_id from cell where patient_chipid IN
('Duke00001_plateC_F11.CEL')").fetchall()
*********************************************************************************
value of result is [(2,), (1,), (-1,), (1,), (1,), (-1,)...]
Please CC me on any reply. Thanks.
Regards, Faheem Mitha.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---