Re: [GENERAL] Is there any ways to pass an array as parameter in libpq?

2009-10-27 Thread ChenXun
on by converting the array to a string using sprintf(). Btw, it seems that the libpqtypes is what I need. Thanks for your reply. Best, Xun Subject: Re: [GENERAL] Is there any ways to pass an array as parameter in libpq? From: cr...@postnewspapers.com.au To: p.smas...@hotmail.com CC: pgsql-ge

Re: [GENERAL] Is there any ways to pass an array as parameter in libpq?

2009-10-27 Thread Merlin Moncure
2009/10/26 ChenXun : > 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 befo

Re: [GENERAL] Is there any ways to pass an array as parameter in libpq?

2009-10-26 Thread Craig Ringer
On Tue, 2009-10-27 at 08:07 +0800, ChenXun wrote: > 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

[GENERAL] Is there any ways to pass an array as parameter in libpq?

2009-10-26 Thread ChenXun
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 pla