After change the SQL clause to "SELECT * from mytable WHERE mykey=$1::int8", the binding passed!
Thanks for everyone's reply.
----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "flying2001us@yahoo.com" <flying2001us@yahoo.com>
Cc: pgsql-general@postgresql.org
Sent: Thursday, April 19, 2007 8:41:22 PM
Subject: Re: [GENERAL] binding 64-bit integer
"flying2001us@yahoo.com" <flying2001us@yahoo.com> writes:
> I wanted to bind a 64-bit integer, but it failed:
> "ERROR: incorrect binary data format in bind
> parameter 1".
It sorta looks like you are trying to send that value to a parameter
that the server doesn't think is int8.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com