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(at)wolff(dot)to>
To: "Yudie" <yudie(at)axiontech(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)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(at)axiontech(dot)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.