How to get another variable type from sql query
<p>From this query...</p>

<pre><code>self.cur.execute("""SELECT pub FROM "20091229"
                 GROUP BY pub ORDER BY pub""")
</code></pre>

<p>I get the following list with tuples back.</p>

<pre><code>&gt;&gt;[(1,), (2,), (3,)]
</code></pre>

<p>But I need only a list or a list without decimal points in the tuples.
Something like these:</p>

<pre><code>[1, 2, 3]
</code></pre>

<p>or</p>

<pre><code>[(1), (2), (3)]
</code></pre>

<p>Thanks.</p>
