Received: from engine9.dnet.net.id (engine9.dnet.net.id [202.148.1.21]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA45675 for ; Thu, 26 Aug 1999 04:40:09 -0400 (EDT) (envelope-from hariss@dnet.net.id) Received: from hariss.dnet.net.id (hariss.dnet.net.id [202.148.1.205]) by engine9.dnet.net.id (8.8.5/8.8.5) with ESMTP id QAA20662 for ; Thu, 26 Aug 1999 16:58:01 +0700 Date: Thu, 26 Aug 1999 15:37:21 +0700 From: Haris Susanto X-Mailer: The Bat! (v1.34a) UNREG / CD5BF9353B3B7091 Reply-To: Haris Susanto X-Priority: 3 (Normal) Message-ID: <13650.990826@dnet.net.id> To: pgsql-sql-digest Subject: money format In-reply-To: <199908240300.XAA66892@hub.org> References: <199908240300.XAA66892@hub.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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