From: | Justin <justin(at)emproshunts(dot)com> |
---|---|
To: | Kless <jonas(dot)esp(at)googlemail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Money data type - Deprecated? |
Date: | 2008-05-26 19:46:39 |
Message-ID: | 483B139F.3040400@emproshunts.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thats a good Question is the Money type ever going to die i believe it
was deprecated several versions ago?
I use the money type a formatting step in select statements when
displaying data on the client only. It saves me setting up input mask
and what not on client side.
There are draw backs to using the money type
dumps/restores can go wrong
many frameworks convert money data type back to numeric or cast it
to String type
I would never have and never will use money as a data type in tables as
the precision is fixed to 2
Kless wrote:
> Does the money data type is deprecated?
>
> That says in 8.2 docs [1]. But I'm not sure why that notice doesn't
> appear in the 8.3 docs [2] .
>
>
> [1] http://www.postgresql.org/docs/8.2/static/datatype-money.html
> [2] http://www.postgresql.org/docs/8.3/static/datatype-money.html
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2008-05-26 20:05:09 | Re: Money data type - Deprecated? |
Previous Message | Adam Rich | 2008-05-26 19:31:37 | Re: internal function format diff |