From: | Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr> |
---|---|
To: | Alexander Scholz <alexander(dot)scholz1(at)freenet(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problem: libpq, network traffic, memory usage |
Date: | 2005-12-07 17:44:52 |
Message-ID: | 20051207174452.GB532@alamut |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Dec 07 06:36, Alexander Scholz wrote:
> sorry for probably asking such a stupid question, but we are using a
> PQexec(). Where should I specify that cursor declaration?
Just like as you're querying with pgAdmin:
PQexec(conn, "BEGIN");
PQexec(conn, "DECLARE \"test\" CURSOR FOR SELECT * FROM \"TEST\"");
for (...)
{
PQexec(conn, "FETCH FORWARD 100 from \"test\"");
/* Use just retrieved result. */
/* Don't forget to clear used PGresult. */
}
PQexec(conn, "...");
--
"We are the middle children of history, raised by television to believe
that someday we'll be millionaires and movie stars and rock stars, but
we won't. And we're just learning this fact," Tyler said. "So don't
fuck with us."
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2005-12-07 17:51:19 | Re: [pgsql-de-allgemein] Query SELECT * sehr langsam |
Previous Message | Bruce Momjian | 2005-12-07 17:44:27 | Re: [GENERAL] Map of Postgresql Users (OT) |