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 <[EMAIL PROTECTED]>
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
