PHP Manual

PEAR Manual

Smarty Manual

PostgreSQL

MySQL Manual

Perl Manual

postgresql 8.2devel documentation
prevfast backwardchapter 8. data typesfast forwardnext

8.2. monetary types

note: the money type is deprecated. use numeric or decimal instead, in combination with the to_char function.

the money type stores a currency amount with a fixed fractional precision; see table 8-3. input is accepted in a variety of formats, including integer and floating-point literals, as well as "typical" currency formatting, such as '$1,000.00'. output is generally in the latter form but depends on the locale.

table 8-3. monetary types

namestorage sizedescriptionrange
money4 bytescurrency amount-21474836.48 to +21474836.47
prevhomenext
data typesupcharacter types