Date: Mon, 6 Jan 2003 10:40:09 -0600
From: "Chris Boget" <chris@wild.net>
Subject: Typcasting
>
> I'm told that I need to cast the value manually.
> I've looked up the CAST function and tried everything that I
> could think of but nothing seems to work. I can't, for the life
> of me, move the data over.
> I can I cast a field value? Is there any other way to do what
> I'm trying to do?
>
Cast only works between compatible data types (int to float etc.)
In your case, to_number() should do what you need.
Christoph Dalitz