I just did a fresh build from current cvs and found the following
regression from 7.2:
create table test (cola bigint);
update test set cola = 10000000000;
In 7.3 the update results in the following error:
ERROR: column "cola" is of type 'bigint' but expression is of type
'double precision'
You will need to rewrite or cast the expression
In 7.2 the update worked. (updated 0 rows in this case)
It is interesting to note that if I use 'cola = 10000000000' in a where
clause instead of as an assignment (i.e. select * from test where cola =
10000000000) this works in both 7.3 and 7.2.
thanks,
--Barry