Thread: force justification of columns

force justification of columns

From
"Johnson, Shaunn"
Date:

Howdy:

I'm trying to create an table where certain fields are suppose to be justified.
I think by default numerical columns justify to the right and text to the
left (seem like it to me).

Is there a way to -force- a column to justify data one way or another
when designing the table?

Thanks!

-X

Re: force justification of columns

From
wsheldah@lexmark.com
Date:

Justification is a function of the tool you use to display the data. It's not a
property of the table or of the database. What are you using to display the
data?




"Johnson, Shaunn" <SJohnson6%bcbsm.com@interlock.lexmark.com> on 01/03/2002
04:03:25 PM

To:   pgsql-general%postgresql.org@interlock.lexmark.com
cc:    (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject:  [GENERAL] force justification of columns




Howdy:

I'm trying to create an table where certain fields are suppose to be justified.
I think by default numerical columns justify to the right and text to the
left (seem like it to me).

Is there a way to -force- a column to justify data one way or another
when designing the table?

Thanks!

-X






Re: force justification of columns

From
"Johnson, Shaunn"
Date:
--Thanks for the replies:
 
--Let me give you an example of what I (believe) need to do.
 
--Based on a request from the higher ups in the company, they have
designed a table format that has unique properties (the attributes of
the columns).
 
--One such is a column that is a concatenation of two fields from
another table.  The only thing I'm doing for THAT is:
 
[example]
 
select contract || '  ' || client_id_num as new_id from legal_dept
 
[/example]
 
But they also put in stipulations that the fields should match what
another vendor has ... and the vendor's table design states that
each column is either right justified or left justified.  AND it
seems to me that the fields are going to be that way because it
appears as such.  BUT there are a few columns that are not
specified ... I was thinking that I'd have to force a justification
for a field to comply with a particular table design from another
company.
 
*whew*
 
--Looks like I'm working too hard for no reason, hm?
 
-X
 
-----Original Message-----
From: Johnson, Shaunn
Sent: Thursday, January 03, 2002 4:03 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] force justification of columns

Howdy:

I'm trying to create an table where certain fields are suppose to be justified.
I think by default numerical columns justify to the right and text to the
left (seem like it to me).

Is there a way to -force- a column to justify data one way or another
when designing the table?

Thanks!

-X