Postgres (7.3.2) doesn't seem to know how to add smallint's to bigint's ...
PG=# select 8::smallint + 8::bigint;
ERROR: Unable to identify an operator '+' for types 'smallint' and 'bigint'
You will have to retype this query using an explicit cast
This is surely just an oversight right?
I was trying to add two columns, a smallint col to a bigint col, and
store the result in the bigint col ... only to find to my surprise that
PostgreSQL didn't know how to add smallints to bigints ...
This will be fixed right? ;)
Jc