Re: String Concatenation

----- Original Message -----

From: Luiz K. Matsumura

To: pgsql-novice@postgresql.org

Sent: Friday, July 23, 2004 9:00 AM

Subject: [NOVICE] String Concatenation

I want to concatenate 2 fields :

tpmov char(4)  | dsmov char(10)

---------------+----------------

AB             | SOMETHING

 

If I do:

 

SELECT tpmov || dsmov as History ...

 

if the field tpmov has a fixed lenght of char(4) the result

expected (I suppose) may be

 

History

--------------

AB  SOMETHING

 

But Postgres returns

 

History

------------

ABSOMETHING

 

Why this occurs ?

How I can get the first result ( AB__SOMETHING ) ?

 

If I do a select with the literal strings the result is as expected :

 

SELECT 'AB  ' || 'SOMETHING' AS History ;

 

History

--------------

AB  SOMETHING

 

My reasoning is wrong or this is a bug ?