From: | Bill Sneed <bsneed(at)mint(dot)net> |
---|---|
To: | "pgsql-general(at)hub(dot)org" <pgsql-general(at)hub(dot)org> |
Subject: | Money |
Date: | 1998-12-12 22:09:19 |
Message-ID: | 3672E98E.B3C125F2@mint.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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......
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-12-12 22:49:19 | Re: [GENERAL] alter table ? |
Previous Message | Bruce Momjian | 1998-12-12 21:47:42 | Re: [GENERAL] PL/pgSQL |