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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to