Postgres Pro
Downloads
Home   >   mailing lists

Re: Looks are important - Mailing list pgsql-sql

From Louise Cofield
Subject Re: Looks are important
Date
Msg-id 003a01c3a973$743eed00$7801a8c0@Louise
Whole thread Raw
In response to Looks are important  ("George Weaver" <georgew1@mts.net>)
List pgsql-sql
Tree view
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@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
 
 
 
 

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Looks are important
Next
From: "George Weaver"
Date:
Subject: Re: Looks are important