Postgres Pro
Downloads
Home   >   mailing lists

Looks are important - Mailing list pgsql-sql

From George Weaver
Subject Looks are important
Date
Msg-id 00ac01c3a96a$a165b290$6400a8c0@Dell4500
Whole thread Raw
Responses Re: Looks are important  (Josh Berkus <josh@agliodbs.com>)
Re: Looks are important  ("Louise Cofield" <lcofield@box-works.com>)
List pgsql-sql
Tree view
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
 
 
 
 

pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: transaction processing after error in statement
Next
From: Josh Berkus
Date:
Subject: Re: Looks are important