Barry Lind <barry@xythos.com> writes:
> create table test (cola bigint);
> update test set cola = 10000000000;
> ERROR: column "cola" is of type 'bigint' but expression is of type
> 'double precision'
> You will need to rewrite or cast the expression
dtoi8 is currently marked "not proimplicit". People seem to have lost
interest in the discussion thread about which coercions should be allowed
implicitly, but the issues still need to be resolved before 7.3.
This particular example perhaps says that when assigning to a table
column, we should allow not-proimplicit coercions to be invoked
implicitly anyway. Since there isn't any question about either the
source type or the target type, allowing this case doesn't seem to pose
any risk of surprising choices being made.
Comments anyone?
regards, tom lane