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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group