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

Started by postgresover 27 years ago1 messagesgeneral
Jump to latest
#1postgres
postgres@korea.co.kr

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.