Money

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......

Responses

Browse pgsql-general by date

  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