John Lim ([EMAIL PROTECTED]) 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
