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 Type Formatting Functions
Regards,
Tomasz Myrta