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 <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sent: Thursday, April 19, 2007 8:41:22 PM
Subject: Re: [GENERAL] binding 64-bit integer
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
