Re: cast varchar to numeric/money

I don't have to_numeric function in my 7.2.2 postgre.
then it can resolve it with: 

cast(substr(varcharcolumn,0) as float4)

thanks.



----- Original Message ----- 
From: "Bruno Wolff III" <bruno@wolff.to>
To: "Yudie" <yudie@axiontech.com>
Cc: <pgsql-sql@postgresql.org>
Sent: Friday, November 21, 2003 11:55 AM
Subject: Re: [SQL] cast varchar to numeric/money


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.