Postgres Pro
Downloads
Home   >   mailing lists

Re: where'd the spaces come from - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: where'd the spaces come from
Date
Msg-id 200108021631.f72GV8T03473@candle.pha.pa.us
Whole thread Raw
In response to Re: where'd the spaces come from  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List pgsql-sql
Tree view 
> 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,
Pennsylvania19026

pgsql-sql by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Fuzzy matching?
Next
From: "Robby Slaughter"
Date:
Subject: RE: Foreign key