Bug #811: Using || with char and char varying

John Lim (heyjohnlim(at)yahoo(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Using || with char and char varying

Long Description
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" (
"id" int4,
"firstname" char(24),
"lastname" varchar,
"created" date
);

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.

Sample Code

No file was uploaded with this report