converting text to float?

From: Bart Ogryczak <bart(at)bart(dot)w-wa(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: converting text to float?
Date: 1999-08-12 12:48:08
Message-ID: 37B2C288.CD6AAB65@bart.w-wa.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)bart(dot)w-wa(dot)pl || http://www.bart.w-wa.pl

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Holbrook 1999-08-12 14:03:47 Running out of memory...
Previous Message Cesar Lombao 1999-08-12 11:02:32 Re: [GENERAL] Problem with compiled C