Re: to_char(0,'9999.99') -> ".00"

to_char(0,'9990.00')
?

On Mon, 2005-01-10 at 22:48 +0000, Phil Endecott wrote:
> Dear All,
>
> I was a bit surprised to find that
>
> to_char(0,'9999.99')
>
> returns .00 rather than 0.00.
>
> Is this a bug or a feature? How do I get what I want?
>
> (This is with 7.4.2. Appologies if it is a known problem. The search
> form in the list archives seems to split words on _, so looking for
> to_char finds lots of pages that just say 'char'.)
>
> Regards,
>
> Phil Endecott.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
Dave Smith <dave(dot)smith(at)candata(dot)com>