Re: where'd the spaces come from

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: where'd the spaces come from
Date: 2001-08-02 16:31:08
Message-ID: 200108021631.f72GV8T03473@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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 correct way to do this, right? There is no bug?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robby Slaughter 2001-08-02 18:19:46 RE: Foreign key
Previous Message Lorenzo De Vito 2001-08-02 16:23:54 Foreign key