Thread: [Question] Help me with programming in C/C++

[Question] Help me with programming in C/C++

From
"postgres"
Date:
Hi.
 
I have a question regarding programming in C and postgreSQL.
 
Is there any way that I can save couple of results to one PGresult * ??
 
Like this
------------------------
BEGIN;
DECLARE portal1 CURSOR FOR select * from item where item = 'aa';
DECLARE portal2 CURSOR FOR select * from item where item = 'bb';
DECLARE portal3 CURSOR FOR select * from item where item = 'cc';
 
res = PQexec(conn,"FETCH ALL in portal*");  // Like this
END;
------------------------
portal1 sould go first.
I really need this function.
I'm a C programmer but not a expert.
If anyone know how to do this in C/C++...
Please let me know..
 
Thanks in advence.