> Hi Bruce,
>
> a fix for what?
> If you're meaning the leading space, then the fix is in the followup post
> that I made to my original quiestion. i.e.
>
> psql -c "select to_char(12,'xFM000');"
> to_char
> -
> x012
> (1 row)
>
> The 'FM' removes the space.
So the FM is the correc
From: "Bruce Momjian" <[EMAIL PROTECTED]>
> > Hi Bruce,
> >
> > a fix for what?
> > If you're meaning the leading space, then the fix is in the followup
post
> > that I made to my original quiestion. i.e.
> >
> > psql -c "select to_char(12,'xFM000');"
> > to_char
> > -
> > x012
> > (1 r
Hi Bruce,
a fix for what?
If you're meaning the leading space, then the fix is in the followup post
that I made to my original quiestion. i.e.
psql -c "select to_char(12,'xFM000');"
to_char
-
x012
(1 row)
The 'FM' removes the space.
Gary
On Thursday 02 August 2001 4:50 pm, Bruce
Does anyone have a fix for this?
> From: "Gary Stainburn" <[EMAIL PROTECTED]>
>
> > 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- 03
From: "Gary Stainburn" <[EMAIL PROTECTED]>
> 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- 03
> SW/ 041- 05
Looks like a buglet in to_char()s ha
Hi all,
forget it, I've solved it. I converted the calls to:
to_char(t.tnumber,'FM000')
and it worked.
Gary
On Monday 23 July 2001 10:18 am, Gary Stainburn wrote:
> Hi all,
>
> Can someone please explain how to remove the spaces from the results of the
> query below. The current output is al
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
