X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 20BC8D1B4F6 for ; Fri, 21 Nov 2003 17:50:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 52416-07 for ; Fri, 21 Nov 2003 13:50:05 -0400 (AST) Received: from axiontctxus1.axiontech.com (unknown [216.52.172.78]) by svr1.postgresql.org (Postfix) with SMTP id 64F14D1B4E6 for ; Fri, 21 Nov 2003 13:50:03 -0400 (AST) Received: (qmail 7112 invoked by uid 104); 21 Nov 2003 17:49:48 -0000 Received: from yudie@axiontech.com by axiontctxus1 with network-box scanner-1.10 (received+scanned in 2.225392 secs); 21 Nov 2003 17:49:48 -0000 X-Scanned-By-axiontctxus1: Virus scan performed by network-box (www.network-box.com) X-Scanned-By-axiontctxus1: Scanner file id is axiontctxus110694369854837104 X-Scanned-By-axiontctxus1: No known viruses found in message (received+scanned in 2.225392 secs) X-Scanned-By-axiontctxus1: Spam-Check-Result: No, hits=-95.9 required=6.0 tests=AWL, BAYES_99, USER_IN_WHITELIST autolearn=no version=2.60 Received: from unknown (HELO axiontech.com) (216.52.172.74) by 216.52.172.68 with SMTP; 21 Nov 2003 17:49:45 -0000 Received: (qmail 30788 invoked from network); 21 Nov 2003 17:49:45 -0000 Received: from pc-00132 (HELO yudie) (192.168.1.132) by mail.axiontech.com (192.168.1.6) with SMTP; 21 Nov 2003 17:49:44 -0000 Message-ID: <000f01c3b057$918a0210$8401a8c0@home.axiontech.com> From: "Yudie" To: References: <200311211422.PAA13790@rodos> Subject: cast varchar to numeric/money Date: Fri, 21 Nov 2003 11:47:42 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=REFERENCES X-Spam-Level: X-Archive-Number: 200311/260 X-Sequence-Number: 16075 Hi guys, I know it's impossible to just cast varchar to any numeric datatype, but is there another function/ custom function or any way to force to do that convertion. please help Thanks.. Yudie