"Mavinakuli, Prasanna (STSD)" <prasanna.b-m@xxxxxx> writes: > Here is the code snapshot: > string query="select intval from dummy where intval=7;"; > res1=PQexecParams(conn,query.c_str(),0,NULL,NULL,NULL,NULL,1); > for(unsigned char i=0;i<4;i++) > { > printf("%d \n",(PQgetvalue(res1,0,0)[i])); > //prints 0000 here > } Um, what's the actual data type of intval? The above would be expected if it were, say, bigint. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend