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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
