Re: binding 64-bit integer

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(at)sss(dot)pgh(dot)pa(dot)us>
To: "flying2001us(at)yahoo(dot)com" <flying2001us(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Sent: Thursday, April 19, 2007 8:41:22 PM
Subject: Re: [GENERAL] binding 64-bit integer

"flying2001us(at)yahoo(dot)com" <flying2001us(at)yahoo(dot)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