John Lim (heyjohnlim(at)yahoo(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
Using || with char and char varying
The following sql:
select firstname||lastname from adoxyz;
generates this error:
PostgreSQL said: ERROR: Unable to identify an operator '||' for types 'character' and 'character varying' You will have to retype this query using an explicit cast
Based on the table:
CREATE TABLE "adoxyz" (
Although this can be fixed by a typecast, porting sql (which i am doing) from other databases such as oracle/mysql is a big pain.
Thanks for looking into this.
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: Fabien Fischer||Date: 2002-11-07 14:54:52|
|Subject: I can't start postgres anymore|
|Previous:||From: Lars||Date: 2002-11-07 08:25:23|
|Subject: like not using indexes in 7.3b5?|