Re: binding 64-bit integer - Mailing list pgsql-general

From Tom Lane
Subject Re: binding 64-bit integer
Date
Msg-id 20122.1177137623@sss.pgh.pa.us
Whole thread Raw
In response to Re: binding 64-bit integer  ("flying2001us@yahoo.com" <flying2001us@yahoo.com>)
List pgsql-general
"flying2001us@yahoo.com" <flying2001us@yahoo.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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Modify existing index
Next
From: RPK
Date:
Subject: Re: Modify existing index