Dnia 2003-11-21 19:26, Użytkownik Yudie napisał:
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)
Read once again. The function is not "to_numeric", but "to_number".
You can read about this function in manual:
6.7. Data Typ
TECTED]>
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 <[EMAIL PROTECTED]> wrote:
> Hi guys,
>
> I know it's impossible to just cast varchar to any numeric datatype,
> but is
On Fri, Nov 21, 2003 at 11:47:42 -0600,
Yudie <[EMAIL PROTECTED]> 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 num
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
---(end of broadcast)---
TIP 9: the planner will i
