where'd the spaces come from

Поиск
Список
Период
Сортировка
От Gary Stainburn
Тема where'd the spaces come from
Дата
Msg-id 01072310180800.26815@gary.ringways.co.uk
обсуждение исходный текст
Ответы Re: where'd the spaces come from  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Список pgsql-sql
Hi all,

Can someone please explain how to remove the spaces from the results of the 
query below.  The current output is also included.  What I want out of the 
query is something like 'NE/027-05'.

psql -c "select t.tregion || '/' || to_char(t.tnumber,'000') || '-' || 
to_char(m.mnumber,'00') as unitno from teams t, members m 
where m.mteam = t.tid;"  unitno
-------------SW/ 041- 03SW/ 041- 05NE/ 011- 06NE/ 011- 01NE/ 011- 03NE/ 011- 02NE/ 011- 10
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     


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

Предыдущее
От: darcy@druid.net (D'Arcy J.M. Cain)
Дата:
Сообщение: Re: Get the tables names?
Следующее
От: Gary Stainburn
Дата:
Сообщение: Re: where'd the spaces come from