| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | sreejith s <getsreejith(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: "Money" Data Type Problem |
| Date: | 2005-04-19 13:59:01 |
| Message-ID: | 20050419065638.B72646@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tue, 19 Apr 2005, sreejith s wrote:
> Hai friends,
> I have a field with data type 'Money' with my table. I select this
> field a select query and displays the same in a textbox. While doing
> this a dollar ($) is prefixed to the actual table value. How to avoid
> this symbol so as to display the actual value only. Any format change
> needed in config files. Pls forward me the reply.
I believe money uses the currency symbol based on LC_MONETARY so there
might exist one without a symbol, however you'd probably be best off
replacing money with an appropriate numeric field.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Fradkin | 2005-04-19 14:06:07 | trying to do an update a bit confused. |
| Previous Message | Andrew Sullivan | 2005-04-19 13:25:47 | Re: Query about SQL in PostgreSQL |