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 sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to