X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 97F655399A for ; Tue, 19 Apr 2005 04:37:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82849-03 for ; Tue, 19 Apr 2005 07:37:06 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.192]) by svr1.postgresql.org (Postfix) with ESMTP id 9302853986 for ; Tue, 19 Apr 2005 04:37:05 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so1990274wra for ; Tue, 19 Apr 2005 00:37:07 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=i/WaiOKNubUOeDDA7/EWaY6pABLoGVjBFflSYY5h0WF6JRWeLgf8xZhAOiwH+ev/GdP/520UzxcNxvGI2+9HQX8etstvIqN15fPrx0cUBHF7bFNreh4+We300R3SrZFJxzasWkt5nQx1dr1HVy40pK21njgivcLNrY00qpFvQEc= Received: by 10.54.48.48 with SMTP id v48mr3141697wrv; Tue, 19 Apr 2005 00:37:07 -0700 (PDT) Received: by 10.54.4.42 with HTTP; Tue, 19 Apr 2005 00:37:07 -0700 (PDT) Message-ID: <5d14ecf905041900375fbceed4@mail.gmail.com> Date: Tue, 19 Apr 2005 13:07:07 +0530 From: sreejith s Reply-To: sreejith s To: pgsql-sql@postgresql.org Subject: "Money" Data Type Problem Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.211 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/276 X-Sequence-Number: 21169 Hai friends, I have a field with data type 'Money' with my table. I select this field a select query and displays the same in a textbox. While doing this a dollar ($) is prefixed to the actual table value. How to avoid this symbol so as to display the actual value only. Any format change needed in config files. Pls forward me the reply. Sreejith