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.
