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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
