Re: [SQL] Type Conversion: int4 -> Money

-----Original Message-----
From: secret <secret@kearneydev.com>
To: Herouth Maoz <herouth@oumail.openu.ac.il>
Cc: pgsql-sql@postgreSQL.org <pgsql-sql@postgreSQL.org>
Date: Thursday, September 09, 1999 3:31 PM
Subject: Re: [SQL] Type Conversion: int4 -> Money


>Herouth Maoz wrote:
>

...

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


from the Perl Cookbook (a Perl-programmer must have!):   sub commify   {       my $text = reverse $_[0];       $text =~
s/(\d\d\d)(?=\d)(?!\d*\.)/$1,/g;      return scalar reverse $text;   }
 

If you want a locale-using solution, and can use C, there's code in the
pgsql source that does this.  Look at:
   /src/backend/utils/adt/cash.c cash_out()