Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f72GZNf62113 for ; Thu, 2 Aug 2001 12:35:23 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.10.1/8.10.1) id f72GV8T03473; Thu, 2 Aug 2001 12:31:08 -0400 (EDT) From: Bruce Momjian Message-Id: <200108021631.f72GV8T03473@candle.pha.pa.us> Subject: Re: where'd the spaces come from In-Reply-To: <01080216562606.18757@gary.ringways.co.uk> "from Gary Stainburn at Aug 2, 2001 04:56:26 pm" To: Gary Stainburn Date: Thu, 2 Aug 2001 12:31:08 -0400 (EDT) CC: Richard Huxton , pgsql-sql X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200108/16 X-Sequence-Number: 4237 > 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@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026