Re: "Money" Data Type Problem - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: "Money" Data Type Problem
Date
Msg-id 20050419065638.B72646@megazone.bigpanda.com
Whole thread Raw
In response to "Money" Data Type Problem  (sreejith s <getsreejith@gmail.com>)
List 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.



pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Query about SQL in PostgreSQL
Next
From: "Joel Fradkin"
Date:
Subject: trying to do an update a bit confused.