Re: binding 64-bit integer

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
Subject: Re: binding 64-bit integer
Date: 2007-04-21 06:40:23
Message-ID: 20122.1177137623@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"flying2001us(at)yahoo(dot)com" <flying2001us(at)yahoo(dot)com> writes:
> After change the SQL clause to "SELECT * from mytable WHERE mykey=$1::int8", the binding passed!

If you had to insert an explicit cast, it means that "mykey" isn't int8,
which makes one wonder why you are bothering.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message RPK 2007-04-21 07:20:45 Re: Modify existing index
Previous Message Peter Eisentraut 2007-04-21 06:37:43 Re: Modify existing index