Postgres Pro
Downloads
Home   >   mailing lists

to_char(0,'9999.99') -> ".00" - Mailing list pgsql-general

From Phil Endecott
Subject to_char(0,'9999.99') -> ".00"
Date
Msg-id 41E30635.7070106@chezphil.org
Whole thread Raw
Responses Re: to_char(0,'9999.99') -> ".00"  (Dave Smith <dave.smith@candata.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Limiting USAGE to only certain objects within a schema
Next
From: Aaron Steele
Date:
Subject: warning: pg_query(): Query failed