From: secret <secret@kearneydev.com>
To: Herouth Maoz <herouth@oumail.openu.ac.il>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Type Conversion: int4 -> Money
Date: Thu, 09 Sep 1999 16:03:19 -0400
Message-ID: <37D81287.ECD01CAC@kearneydev.com> (raw)
References: <l03130302b3a8f069c1cd@[147.233.159.109]>
Herouth Maoz wrote:
> At 21:49 +0300 on 06/07/1999, secret wrote:
>
> > Is there a way to convert an int4 into a money? I have a few reports
> > that require format of int4 as a money(I didn't use money for money
> > because it's very difficult to convert money into other types it
> > seems)...
>
> What language do you use for creating the report? Most of the time, you can
> get the integer in the frontend (the report program), and format it using
> some formatting routine.
>
> > The only way I can figure out how to do it is a kludge, such as:
> >
> > CREATE TABLE z(a int4, b money);
> >
> > Fill a with appropriate values, then set b as "1". SELECT a*b as a FROM
> > z... And your done... But there should be some easier way to convert an
> > int4 into a money rather than mulitply it?
>
> You can multiply it without creating a special table for it. For example,
> here is a test table:
>
> testing=> select num, num * '1'::money from test1;
> num|?column?
> ------+-----------
> 2|$2.00
> 4|$4.00
> -14|($14.00)
> 38|$38.00
> 199|$199.00
> 100399|$100,399.00
> (6 rows)
>
> Is that what you wanted?
>
> Herouth
>
> --
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
> http://telem.openu.ac.il/~herutma
Perl... I ended up writing my own formatting function... It has one that
does ####.## however not one that'll do the nice 123,456.33 ... :) Do you know
if there are any public modules that do such things?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: secret@kearneydev.com, herouth@oumail.openu.ac.il
Subject: Re: [SQL] Type Conversion: int4 -> Money
In-Reply-To: <37D81287.ECD01CAC@kearneydev.com>
References: <l03130302b3a8f069c1cd@[147.233.159.109]> <37D81287.ECD01CAC@kearneydev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox