Problem cocatenating String (||)

From: "Thomas Niemeier" <thomas(dot)niemeier(at)case-bielefeld(dot)de>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Problem cocatenating String (||)
Date: 2004-09-13 11:22:11
Message-ID: LDEKJEFHGCCDOFICBKFAGECECDAA.thomas.niemeier@case-bielefeld.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello everybody!

I've got a problem concatenating two fields (char(10) not null) in a select statement. Let's say the first field pname has the value
'USER ' and the second field pfirst the value 'JOE '. Then a "select pname||pfirst from table" would return the value 'USERJOE', trimming all spaces in the fields. This behaviour seems to be new in Release 7.4.5. Release 7.3.2 returns 'USER JOE', which makes more sense to me.
Is there any way to get my spaces back?
I'm working on SuSE-Linux 8.2

Best wishes

Thomas Niemeier

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message wisan watcharinporn 2004-09-13 13:02:34 table and column name
Previous Message Kris Jurka 2004-09-13 10:53:49 Re: BUG #1251: setTransactionIsolation does not seem to work