converting text to float?
От | Bart Ogryczak |
---|---|
Тема | converting text to float? |
Дата | |
Msg-id | 37B2BED6.1F7005E2@bart.w-wa.pl обсуждение исходный текст |
Список | pgsql-sql |
Hey, I'm trying hard to convert text to float, and all i get are messages like this: select float4(wartosc) from tblwartosci ; ERROR: Function 'float4(text)' does not exist There is more than one function that satisfies the given argument types You will have to retype your query using explicit typecasts select float4(int(wartosc)) from tblwartosci ; ERROR: pg_atoi: error in "285.75": can't parse ".75" Table = tblwartosci +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ . . | wartosc | text | var | +----------------------------------+----------------------------------+-------+ Is there a resonable way to do text to float conversion? bart -- bart@bart.w-wa.pl || http://www.bart.w-wa.pl
В списке pgsql-sql по дате отправления: