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@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