Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group