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 18013D1B50A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 21 Nov 2003 17:57:06 +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 52421-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 21 Nov 2003 13:56:35 -0400 (AST)
Received: from wolff.to (wolff.to [66.93.249.74])
	by svr1.postgresql.org (Postfix) with SMTP id D1F85D1D3FB
	for <pgsql-sql@postgresql.org>; Fri, 21 Nov 2003 13:56:33 -0400 (AST)
Received: (qmail 4210 invoked by uid 500); 21 Nov 2003 17:55:23 -0000
Date: Fri, 21 Nov 2003 11:55:23 -0600
From: Bruno Wolff III <bruno@wolff.to>
To: Yudie <yudie@axiontech.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: cast varchar to numeric/money
Message-ID: <20031121175523.GA4065@wolff.to>
Mail-Followup-To: Yudie <yudie@axiontech.com>,
	pgsql-sql@postgresql.org
References: <200311211422.PAA13790@rodos>
	<Pine.GSO.4.58.0311211730170.13158@ra.sai.msu.su>
	<000f01c3b057$918a0210$8401a8c0@home.axiontech.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <000f01c3b057$918a0210$8401a8c0@home.axiontech.com>
User-Agent: Mutt/1.5.4i
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200311/261
X-Sequence-Number: 16076

On Fri, Nov 21, 2003 at 11:47:42 -0600,
  Yudie <yudie@axiontech.com> wrote:
> 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.

You can use to_number to go from text to numeric.