res = PQexec(conn, "BEGIN");
res = PQexec(conn, "DECLARE myportal CURSOR FOR select * from pg_database");
res = PQexec(conn, "FETCH ALL in myportal");
res = PQexec(conn, "CLOSE myportal");
res = PQexec(conn, "END");Is this just to illustrate how to create transactions and cursors, or is there some material difference between trimming the program down to just:
res = PQexec(conn, "select * from pg_database");
Is there any value in my own query-only programs to declaring the cursor for each search?
Many TIA, Mark
-- Mark Harrison Pixar Animation Studios
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
