remove $ from money field - Mailing list pgsql-general

From Robby Russell
Subject remove $ from money field
Date
Msg-id 3F343A98.5070404@commandprompt.com
Whole thread Raw
Responses Re: remove $ from money field
Re: remove $ from money field
Re: remove $ from money field
List pgsql-general
Should be a simple question.

When selecting a field that is of type money, how can I remove the $
when selected?

example: $10.00 would return as 10.00

-Robby


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Empty Output? How Do I Determine the Character?
Next
From: culley harrelson
Date:
Subject: Re: 7.3.3 behaving differently on OS X 10.2.6 and FreeBSD