Postgres Pro
Downloads
Home   >   mailing lists

Formatting function, simple Q - Mailing list pgsql-novice

From nhrcommu@rochester.rr.com
Subject Formatting function, simple Q
Date
Msg-id c7669ebc45a1f.45a1fc7669ebc@nyroc.rr.com
Whole thread Raw
In response to Re: disallowed characters in table names?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Formatting function, simple Q
List pgsql-novice
Tree view 
Folks,

I reviewed
http://www.postgresql.org/docs/current/static/functions-formatting.html
and I am wondering in the examples section, if there is a way to avoid the
" " between the DM and the 485.

to_char(485, 'L999')    'DM 485

Our locale, I'd be looking for '$485', without a space.
Does this just reflect a US currency quirk?

Thanks,
Mike Ellsworth

pgsql-novice by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: cannot cast type boolean to text?
Next
From: Tom Lane
Date:
Subject: Re: Formatting function, simple Q