Formatting function, simple Q

From: nhrcommu(at)rochester(dot)rr(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: Formatting function, simple Q
Date: 2007-06-15 13:43:12
Message-ID: c7669ebc45a1f.45a1fc7669ebc@nyroc.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2007-06-15 14:20:14 Re: Formatting function, simple Q
Previous Message Shoaib Mir 2007-06-14 18:43:32 Re: cannot cast type boolean to text?