Thread

1. casting question

   hook <hook@kcp.com> — 2002-02-02T15:20:38Z

   
   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....
   
   
   tanks
   
   
   

2. Re: casting question

   Stephan Szabo <sszabo@megazone23.bigpanda.com> — 2002-02-02T18:58:54Z

   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 '').
   
   
   
   

3. Re: casting question

   Jeff Eckermann <jeff_eckermann@yahoo.com> — 2002-02-04T15:05:30Z

   Your fields contain spaces, because of the char(15)
   datatype padding them out.  The numeric conversion
   routine can't handle those spaces: you will need to
   use a trim function (probably rtrim() will be best) to
   take them out.
   
   You can avoid this problem if you use varchar (or
   text) instead of char datatype.
   
   --- "A. Van Hook" <hook@kcp.com> 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....
   > 
   > 
   > tanks
   > 
   > 
   > ---------------------------(end of
   > broadcast)---------------------------
   > TIP 6: Have you searched our list archives?
   > 
   > http://archives.postgresql.org
   
   
   __________________________________________________
   Do You Yahoo!?
   Great stuff seeking new owners in Yahoo! Auctions! 
   http://auctions.yahoo.com