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.