Hello,
I believe that the Int8/BigInt items are known issues but I have a knew programmer that ran into it
over the weekend (he didn't call me when he encountered the problem, when he should of) and we have a
customer that burned some significant time on it as well. Will this be fixed in 7.4?
Well, this is not an issue actually but fact that postgresql is very strict about it's data types. You need to cast explicitly even for those types which 'seem' compatible, such as int4 and int2.
This query:
explain select bid_id, bid_time from bid where bid_id = 10000
Will always sequential scan.
This query:
explain select bid_id, bid_time from bid where bid_id = '10000'
Try explain select bid_id, bid_time from bid where bid_id = 10000::bigint
create function bid_check(bigint) returns bool as ' declare in_bid_id alias for $1; begin
if (select count(*) from bid where bid_id = in_bid_id) = 1 then
Again try typecasting.
if (select count(*) from bid where bid_id::bigint = in_bid_id::bigint) = 1 then
I doubt in_bid_id needs to be casted that explicitly but I am sure it will be safe..:-)
HTH
Shridhar
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])