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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
