Problem concating bpchar and varchar in 7.1.3

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Problem concating bpchar and varchar in 7.1.3
Date: 2001-11-12 08:03:41
Message-ID: GNELIHDDFBOCMGBFGEFOMEFOCAAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I just noticed that you cannot concat a fixed char column and a varchar
column in 7.1.3. Has this been fixed in 7.2? (I can't check it here...)

test=# \d ADOXYZ
Table "adoxyz"
Attribute | Type | Modifier
-----------+-------------------+----------
id | integer |
firstname | character(24) |
lastname | character varying |
created | date |

test=# select firstname || lastname from ADOXYZ;
ERROR: Unable to identify an operator '||' for types 'bpchar' and 'varchar'
You will have to retype this query using an explicit cast

Browse pgsql-hackers by date

  From Date Subject
Next Message Janning Vygen 2001-11-12 09:08:22 Re: psql -f backup.out || file too big
Previous Message Bruce Momjian 2001-11-12 07:09:47 Improve pg_hba.conf