Re: force justification of columns

Поиск
Список
Период
Сортировка
От Johnson, Shaunn
Тема Re: force justification of columns
Дата
Msg-id 73309C2FDD95D11192E60008C7B1D5BB0452DC41@snt452.corp.bcbsm.com
обсуждение исходный текст
Ответ на force justification of columns  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Список pgsql-general
--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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jason Earl
Дата:
Сообщение: Re: Simplicity in time/date functions
Следующее
От: Chris Albertson
Дата:
Сообщение: Re: Shipping database help desperately needed