Horton

Re: casting question

Stephan Szabo <sszabo@megazone23.bigpanda.com>

View thread View on postgr.es
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: "A. Van Hook" <hook@kcp.com>
Cc: <pgsql-sql@postgresql.org>
Date: 2002-02-02T18:58:54Z
Lists: pgsql-sql 
On Sat, 2 Feb 2002, A. Van Hook wrote:

>
>
> I have a column  (quantityonhand     | character(15) | default '' )
> that I would like to use to perform simple math.
> I can't seem to get the syntax for casting and  have tried various
> combinations of "select  to_number(quantityonhand::text, '99G999D9S')".
> Can not get get past ERROR:  Bad numeric input format ' '.
>
>
>     Any help would be greatly  appreciated....

You probably have a value in there which is not convertable to a numeric
(such as the default '').