Hello all,I am having a problem accessing variable length
arrays ( or rather fields ) in postgres tables from
a C program. Can somebody please help me out ?
I've included the source files below. I've have not included
the error checks (CONNECTION_BAD etc).Thanks in advance, -npd
file test.sql
---------------
create table temp (key int4, count int4, a int4[], b int4[]);
insert into temp values( 1, 2, '{1,2}', '{3,4}' );
insert into temp values( 2, 1, '{1}', '{2}' );
insert into temp values( 3, 3, '{1,2,3}', '{3,4,5}' );
file test.c
-------------
include <stdio.h>
#include <pgsql/libpq-fe.h>
main()
{PGconn *conn;PGresult *res;int nf;int i, j, k;
conn = PQsetdb(NULL,NULL,NULL,NULL,"test");res = PQexec(conn,"BEGIN");PQclear(res);res = PQexec(conn,"DECLARE mc BINARY
CURSORFOR select * from temp");PQclear(res);res = PQexec(conn,"FETCH ALL in mc");PQclear(res);
nf = PQnfields(res);
for(i=0;i<PQntuples(res);++i){ int *key, *count; int *a, *b, la, lb; key = PQgetvalue(res,i,0); count =
PQgetvalue(res,i,1); la = PQgetlength(res,i,2); lb = PQgetlength(res,i,3); a = (int *) malloc(la); b = (int
*)malloc(lb); memmove(a,PQgetvalue(res,i,3),la); printf("i = %d key = %d c = %d",i,*key,*count);
for(j=0;j<*count;++j) { printf(" elem a[%d] = %d, b[%d]",j,a[j],j,b[j]); } printf("\n");}
PQclear(res);res = PQexec(conn,"CLOSE mc"); PQclear(res);res = PQexec(conn,"COMMIT"); PQclear(res);PQfinish(conn);
}
Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in