Re: Question about return value of `fetchall()`.

[Genki Marshall]

... I'm really sorry for the spam, I took me trying another library to finally realize my mistake.

It should have been:

```

>>> cursor.execute("SELECT x, y FROM testing")

```

I'm obviously still getting used to SQL. Again, sorry for the spam.

On Friday, August 21, 2015 at 9:21:27 PM UTC-7, Genki Marshall wrote:

Hello,

I think I might be misunderstanding the behavior of `fetchall`:

[using Python version  3.4.3, `pg8000` version 1.10.2 ].

```

>>> cursor.execute("CREATE TABLE testing (x INTEGER, y INTEGER)")

>>> cursor.execute("INSERT INTO testing (x, y) VALUES (1, 2)")

>>> cursor.execute("INSERT INTO testing (x, y) VALUES (3, 4)")

>>> cursor.execute("SELECT (x, y) FROM testing")

>>> cursor.fetchall()

(['(1,2)'], ['(3,4)'])

```

So, the result is:

- A tuple of 2 lists.

- The 2 lists each have only one element in them.

- That element is a string: "(1,2)" in the first list, and the string "(3,4)" in the second list.

The result I would have expected would be:

- A tuple (or any iterable) of 2 lists (or any iterable).

- The 2 lists each have _two_ elements in them (not one).

- Those two elements are "1" and "2" in the first list, then "3" and "4" in the second list.

Or at least something like that.

Basically, any SELECT query I try returns a tuple of lists.

Each list always has just _one_ element.

That one element is a string version of the tuple that I really want.

Could someone enlighten me as to what I'm missing?

Thank you so much for your time.