money data type and conversions
| От | Bruce Momjian |
|---|---|
| Тема | money data type and conversions |
| Дата | |
| Msg-id | 199906221740.NAA21057@candle.pha.pa.us обсуждение исходный текст |
| Ответы |
Re: [HACKERS] money data type and conversions
RE: [HACKERS] money data type and conversions Re: [HACKERS] money data type and conversions |
| Список | pgsql-hackers |
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,
Pennsylvania19026
В списке pgsql-hackers по дате отправления: