From: | Bart Ogryczak <bart(at)bart(dot)w-wa(dot)pl> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | converting text to float? |
Date: | 1999-08-12 12:32:22 |
Message-ID: | 37B2BED6.1F7005E2@bart.w-wa.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)bart(dot)w-wa(dot)pl || http://www.bart.w-wa.pl
From | Date | Subject | |
---|---|---|---|
Next Message | Sbastien BOUTELOUP | 1999-08-12 13:05:00 | What return type for an insertion function? |
Previous Message | Sbastien BOUTELOUP | 1999-08-12 11:39:53 | Problem with postgreSQL triggers |