From: | "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com> |
---|---|
To: | Hans Edwin Winzeler <hewinzeler(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Invalid input syntax for integer |
Date: | 2011-08-18 15:43:04 |
Message-ID: | 20110818174304.6b0cb977@anubis.defcon1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thu, 18 Aug 2011 11:07:58 -0400, Hans Edwin Winzeler <hewinzeler(at)gmail(dot)com>
wrote:
Oops, forgot this one:
> - How do I convert the varchar(20) that I have already imported into a
> numeric value?
you need to:
* add a real/float/numeric/... wanted column to the table,
* use a function that:
read a row,
get the varchar(20) column,
check for beginning with 0-[1-9],
strip '0-' from the string,
convert it into the wanted format,
update table's real/float/numeric/... column with the result,
loop until end of table.
--
Reality is for people who can't deal with drugs.
-- Lily Tomlin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-08-18 15:55:01 | Re: Invalid input syntax for integer |
Previous Message | Jean-Yves F. Barbier | 2011-08-18 15:32:05 | Re: Invalid input syntax for integer |