Money deprecation and cast problem

From: "DanixDefcon5" <danixdefcon5(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Money deprecation and cast problem
Date: 2006-04-24 18:59:08
Message-ID: 1145905148.140026.134730@g10g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Ok, I've been using Postgres for quite some time now (about 6
years-ish), except for a MySQL period b/c of work requirements.
However, I never managed to use some of the more special types in the
DBMS, like 'money'.

I know that the 'money' type is now deprecated, but I wonder why it is,
and also ... how was it supposed to cast any other data type to 'money'
anyway??? I checked the function list, per \df and couldn't find any
function to do so, even though the money data type is basically an int4
with the decimal point moved two places to the left. So....

- Why did they deprecate it?
and
- Why were there no functions to convert data types *to* money? There
were plenty of possible casts *from* money...

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-04-24 20:55:08 Re: Automated setting of timezone with connection pooling
Previous Message George Woodring 2006-04-24 17:25:32 Automated setting of timezone with connection pooling