Re: Looks are important

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of George Weaver
Sent: Wednesday, November 12, 2003 3:12 PM
To: pgsql-sql@postgresql.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