|
Hello, I'm starting to learn programming with libpq. In the main loop of my code, I will receive some data in the format of an array of a struct. The data will be inserted to the database, in different lines. I also need to update the last record in the table before the insertion. So I plan to write a pl/pgsql function (procedure) to perform the whole updating and inserting. But I don't know how to pass the array to the procedure through libpq. It seems the only way is to using libpq to do updating and inserting separately. Like this for(;;) { /* receive data */ /* libpq updating */ PQexec(...); PQprepare(...); for (i=0; i<n; i++) { /* libpq inserting */ PQexecPrepared()... } } The PQprepare function has to be called in each loop.So my question is that whether there is a method to pass the array as parameter to libpq? Best regards, Xun Messenger保护盾2.0，更安全可靠的Messenger聊天！ 现在就下载！ |
