binding 64-bit integer

Hi all,

I'm using Solaris 10 with 64-bit libpq library.

I wanted to bind a 64-bit integer, but it failed:
"ERROR:  incorrect binary data format in bind
parameter 1".

The code would succeed if the type of "val" is
uint32_t.

Doe anyone know how to fix this?  Thanks a lot!

-------------------------------------------------------------------------------------------------
uint64_t  val;
const char      *paramValues[1];
int  paramLengths[1];
int  paramFormats[1];
const char *sql_clause = "SELECT * FROM mytable  WHERE
mykey = $1";

paramValues[0] = (char *) &val;
paramLengths[0] = sizeof(val);
paramFormats[0] = 1;

res = PQexecParams(conn, sql_clause, 1, NULL,
          paramValues, paramLengths, paramFormats, 1);



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com