Money
| От | Bill Sneed |
|---|---|
| Тема | Money |
| Дата | |
| Msg-id | 3672E98E.B3C125F2@mint.net обсуждение исходный текст |
| Ответы |
Re: [GENERAL] Money
|
| Список | pgsql-general |
I' m trying to perform some simple arithmetic with a field datatype,
money.
For example, select part_id, cost from parts; gives the id and cost
in dollars...
select part_id, cost+1.00 from parts; ....adds $1.00 to
displayed cost.
select part_id, cost*2 from parts; produces an error message...
"There is no operator '*' for types money.....retype this query using
an explicit cast or.....define the operator using CREATE OPERATOR."
If I examine the list of operators using \do, there are any number of
them shown for *, money, int2, float4, etc.
Question 1: Is this a list of existing oeprators or a list of
permitted ones that I have to create?
Question 2: I can't figure out haw to use the CAST :: ....Any
hints?
Again, TIA to one and all.
.......Bill Sneed....Prospect, Maine......
В списке pgsql-general по дате отправления: