money data type and conversions

Can someone explain why our money type in 6.5 requires quotes, and why
there is no int() function for it?

---------------------------------------------------------------------------


test=> create table t(x money);
CREATE
test=> insert into t values (3.3);
ERROR:  Attribute 'x' is of type 'money' but expression is of type 'float8'       You will need to rewrite or cast the expression
test=> insert into t values (3.33);
ERROR:  Attribute 'x' is of type 'money' but expression is of type 'float8'       You will need to rewrite or cast the expression
test=> insert into t values (money(3.33));
ERROR:  No such function 'money' with the specified attributes
test=> insert into t values (cash(3.33));
ERROR:  No such function 'cash' with the specified attributes
test=> insert into t values (3.33);
ERROR:  Attribute 'x' is of type 'money' but expression is of type 'float8'       You will need to rewrite or cast the expression
test=> insert into t values ('3.33');
INSERT 18569 1
test=> select int(x) from t;
ERROR:  No such function 'int' with the specified attributes
test=> select int4(x) from t;
ERROR:  No such function 'int4' with the specified attributes

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610) 853-3000 +  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026