money format - Mailing list pgsql-sql

From Haris Susanto
Subject money format
Date
Msg-id 13650.990826@dnet.net.id
Whole thread Raw
List pgsql-sql
Hello pgsql-sql-digest,

I want to ask about currency format in PostgreSQL. Suppose I have a
table like this :

my_money (data type : int)
--------
10000
20000
30000

In which way I can query those record in currency format. But please
don't ask me to convert the data type into money type, coz it means
put me into big trouble ! :)

What I want is like these :

10.000 or 10.000,- or 10.000,00
20.000 or 20.000,- or 20.000,00
30.000 or 30.000,- or 30.000,00

I hope somebody will give me advice.
Thanks in advanced.

Best regards,
Haris                            mailto:hariss@dnet.net.id




pgsql-sql by date:

Previous
From: Michael Richards
Date:
Subject: Re: [SQL] 2 million+ entries
Next
From: Brandon Huey
Date:
Subject: join expression support in 6.5.1?