I just migrated from 8.1 to 8.3, running on FreeBSD 7.0 amd64. Running 8.3.5
I have a query concatenating 3 columns to create a hash. userid is a numeric(38,0) field, accountno is an integer, and requestdate is a date.
Under 8.1, Select userid || accountno || requestdate::date as newcolumn from table executed ok. Under 8.3, it gives the following error:
operator does not exist: numeric || integer
Typecasting the first two columns to varchar resolved the problem.
Select userid::varchar || accountno::varchar || requestdate::date as newcolumn from table At the very least, the documentation should be updated to reflect the new behavior, although I believe this is a bug.