Re: remove $ from money field - Mailing list pgsql-general

From Tom Lane
Subject Re: remove $ from money field
Date
Msg-id 2977.1060398808@sss.pgh.pa.us
Whole thread Raw
In response to remove $ from money field  (Robby Russell <rrussell@commandprompt.com>)
List pgsql-general
Robby Russell <rrussell@commandprompt.com> writes:
> When selecting a field that is of type money, how can I remove the $
> when selected?

Actually, almost the only thing money does for you is put in the $ sign
;-).  I'd recommend using type numeric instead, if you have any desire
for more flexibility.

            regards, tom lane

pgsql-general by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Re: One table in two different databases
Next
From: Tom Lane
Date:
Subject: Re: Random via Subselect or Temporary Table