From: George Weaver <georgew1@mts.net>
To: Josh Berkus <josh@agliodbs.com>
To: pgsql-sql@postgresql.org
To: Louise Cofield <lcofield@box-works.com>
Subject: Re: Looks are important
Date: Wed, 12 Nov 2003 21:14:34 -0600
Message-ID: <002c01c3a994$5ba611d0$6400a8c0@Dell4500> (raw)
References: <003a01c3a973$743eed00$7801a8c0@Louise>
MessageHi Louise, Josh,
Thanks for the suggestions.
What I'm trying to accomplish is to have a space between no and kind. Length(no) can vary. I would like all the kinds to line up evenly when displayed, with a space between no and kind. But when I RPAD no (to try and get an even starting point for kind), the ' 's are not quite the same width as an ordinary number or letter. Thus the physical display length of "30 characters" (padded) can vary from row to row. The result is that the kinds don't necessary line up neatly. I need to concatenate the two as they are being displayed as one column in a drop down combobox.
Is what I'm trying to do possible???
George
----- Original Message -----
From: Louise Cofield
To: 'George Weaver' ; pgsql-sql@postgresql.org
Sent: Wednesday, November 12, 2003 5:19 PM
Subject: RE: [SQL] 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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: georgew1@mts.net, josh@agliodbs.com, lcofield@box-works.com
Subject: Re: Looks are important
In-Reply-To: <002c01c3a994$5ba611d0$6400a8c0@Dell4500>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox