[SQLObject] select only one column, not the whole record
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
|
From: Daniel F. <fet...@go...> - 2008-04-06 05:55:53
|
Hi folks, Is it possible to select only 1 column out of a table and not the whole record? More specifically, what I really need is the following: SELECT DISTINCT column FROM table; The point is that I only need DISTINCT values and if I can't select 1 column only then I can't use DISTINCT because generally full records are never the same but the value in 'column' might be repeated. So I would need to select everything and filter through the data in python which would be a huge performance hit. Cheers, Daniel |