2011/2/9 Anton Maksimenkov <anton200@xxxxxxxxx>
Hi.
I use libpq in my program. And I can retrieve int and symbolic fields
as simple as
int unameFN, moneyFN...
char *unamePTR, *moneyPTR...
unameFN = PQfnumber(res, "uname");
moneyFN = PQfnumber(res, "money");
unamePTR = PQgetvalue(res, 0, unameFN);
moneyPTR = PQgetvalue(res, 0, moneyFN);
themoney  = ntohl(*((uint32_t *) moneyPTR));
printf("user->[uname:%s money:%d]", unamePTR, themoney);
Then I tried to use array type and no success:
int arFN...
char *arPTR...
arN = PQfnumber(res, "woo");
arPTR = PQgetvalue(res, 0, arFN);
printf("user->[woo:%s]", arPTR);
I can convert it with array_to_string() and got it as some text.
My array is the array of integer values. So maybe there is some native
method to retrieve them (as in the 'themoney' example)?
Not in libpq. Probably, in libpqtypes.
--
antonvm
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
// Dmitriy.
