Iterating through cur and cur.fetchone()

From: Håvard Wahl Kongsgård <haavard(dot)kongsgaard(at)gmail(dot)com>
To: psycopg <psycopg(at)postgresql(dot)org>
Subject: Iterating through cur and cur.fetchone()
Date: 2011-10-10 10:57:12
Message-ID: CAKH9109mY1c=wzdBuV24wMDPXM+94vJzUcPZ404EF6BzgYt_AA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hi, how do I use cur.fetchone() when iterating through a cur object.

with
conn = psycopg2.connect()
cur = conn.cursor()
SQL = ('select * from something limit 1000')

n = 1
cur.execute(SQL)
for edge_list in cur:
edge = cur.fetchone()
print n

n = n +1

I get
n = 500

when I skip edge = cur.fetchone()

for edge_list in cur:
print n

n = n +1

n = 1000

Why does this happen, and what is the solution?

--
Håvard Wahl Kongsgård

Responses

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2011-10-10 11:19:14 Re: Iterating through cur and cur.fetchone()
Previous Message Daniele Varrazzo 2011-10-06 15:04:15 Re: 2.4.2: undefined symbol: lo_truncate