Re: Looks are important

Try the TRIM function or the LTRIM function:

SELECT RPAD(no,30,' ') || TRIM(tableb.kind) FROM tablea
WHERE tablea.kind = tableb.kind

Louise

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of George Weaver
Sent: Wednesday, November 12, 2003 3:12 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Looks are important

Hi Everyone,

I am trying to concatenate two fields through a query:

SELECT RPAD(no,30,' ') || tableb.kind FROM tablea
WHERE tablea.kind = tableb.kind

The result gives (for example):

4595448 Green
5966 Yellow
106-60033 Green
15-94-387 Red
217-991173 Blue

What I would like to have is better alignment:

4595448 Green
5966 Yellow
106-60033 Green
15-94-387 Red
217-991173 Blue

Is there some kind of encoding or other string options that will result
in better alignment than what I've tried with Rpad?

Thanks in advance,
George