Postgres Pro
Downloads
Home   >   mailing lists

casting question - Mailing list pgsql-sql

From A. Van Hook
Subject casting question
Date
Msg-id 3C5C03C6.CAE5CAB3@kcp.com
Whole thread Raw
Responses Re: casting question  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: casting question  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Tree view 

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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fractional Results
Next
From: "Steve Boyle \(Roselink\)"
Date:
Subject: Re: test the existence of a database